How would I do this?:I have a new one for you...

[twistededge]

Hi folks - thanks to everyone who's helped me out so far with the previous problem I posted - I have a new one for you...

Take a look at this: http://twistededge.org/excel.jpg

I want to count the number of blank entries in the 'Date Sent' column for each Name.

So, if Name = C3, tell me how many blanks for that Name.

Thanks!

[arthurbr]

=SUMPRODUCT(--(c1:c8=$A$3)*--(d1:d8=""))

[twistededge]

Works great - thank you!