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<"")),"")