DCount?? not working. Pls help

K

KDD

My data is orgnaised as follows:

A B C D E
David 2245 abcd efgh ijk
Susan 2249 xyz etc etc
Mickey 1234 etc 123 etc
Arnold 4321 etc....
David 1441
Mickey abcd
etc etc

I want to count the number of non blank cells in B for each "David", "Susan"
etc in A, and have the value returned in another sheet.

I tried DCount, but it doesnt seem to be working.
 
D

Dave O

I mocked up your data as you provided it, with names in A1:A6 etc. I
entered "David" in A8 and this formula in B8:
=SUMPRODUCT(--($A$1:$A$6=A8),--($B$1:$B$6<>""))
 
Top