=SUMPRODUCT(--(B1:B4>=DATE(2006,1,1))*--(C1:C4=A1))

"Redwing ML" wrote:

> Hello, can you help?
>
> I would like to correct the following formula...This is what I have...
>
> =IF(B1:B4,">=01/01/06"),THENCOUNT,(C1:C4,IF=A1))
>
> This is what my worksheet shows.....
>
> Column A Column B Column C Column D
> A 12/20/05 A (Above Formula)..This
> should=2
> B 12/21/05 C
> C 01/03/06 A
> D 01/21/06 A
>
>
> Can you please help me in how to write the formula correctly???
>
> Thanks so much!