=SUMPRODUCT(--(B1:B4=--"2006-01-01"),--(C1:C4="A"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Redwing ML" <Redwing wrote in message
...
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!