Example

Your formula results:
Assigned To: Number Completed Date
Joe 2 1/1/06
Jane 1
Joe 2 2/22/06
Jane 1 3/12/06
Jim 0

My formula (with errors fixed) results:
Assigned To: Number Completed Date
Joe 2 1/1/06
Jane
Joe 2 2/22/06
Jane 1 3/12/06
Jim

This is what I thought the OP wanted, so I thought it might be slightly more
appropriate.



"Bob Phillips" wrote:

Errors apart, it seems a bit redundant to explicitly test for C being blank
and then do so again in the SP part. If you do that test, COUNTIF would be
somewhat better.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Sloth" wrote in message
...
this modified formula should work a little better.

=IF(C1<"",SUMPRODUCT(--($A$2:$A$200=A2),--($C$1:$C$200<"")),"")



"Bob Phillips" wrote:

=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