Sloth,

This did it. Excellent!

Now, if you feel like answering one more question. What function do
the -- serve.

Thanks for the help.

Jeff


Sloth Wrote:
oops, that's what I get for rushing, sorry about that. The point I was
trying to make was
1) change the A1 to A2, since the first formula will first be pasted
in B2.
2) Add the conditional statement because according to how I understood
the
question, only the completed ones will have a date next to it. In the
example next to Jane is nothing, not 0. And if Jane had other rows
that had
dates, there would incorrectly be a number next to it in the formula
as
originaly posted.

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



"JE McGimpsey" wrote:

I'd think it would give an error, since the ranges aren't the same
size.

Why check the "Date" label? Won't it always be <""?

In article ,
Sloth wrote:

this modified formula should work a little better.

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




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