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.
--
KDDXB