That one I would think would count the blanks if E4 were empty...
Perhaps this might clean it up a bit?
=SUMPRODUCT((name=C4)*(dob=E4)*(dob<>""))
That one I would think would count the blanks if E4 were empty...
Perhaps this might clean it up a bit?
=SUMPRODUCT((name=C4)*(dob=E4)*(dob<>""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks