=SUMPRODUCT(--($A$2:$A$200=A1),--($C$2:$C$200<""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jeffc" wrote in
message ...

This one's got me stumped so any help would be appreciated.

Here's the problem, I've got one column with names in it and a second
column with dates in it. What I'm trying to do is generate a count in a
third column next to each name with the number of times the name appears
in the name column when there is a date in the corresponding date
column. If the date column is blank I want the count column to remain
blank.

For example:

Assigned To: Number Completed Date
Joe 2 1/1/06
Jane
Joe 2 2/22/06


I know that there will be repeated info but the end user doesn't care.


Thanks
Jeff


--
jeffc
------------------------------------------------------------------------
jeffc's Profile:
http://www.excelforum.com/member.php...o&userid=33452
View this thread: http://www.excelforum.com/showthread...hreadid=532621