=SUMPRODUCT(--(A7:A3000="C7"),--(B2:B3000=--"2006-01-01"))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Andyd74" wrote in
message ...

I want to count the number of cells in column B, where two criteria is
true.

I.e. i want to count the number of cells in column B that equal
01/01/2006 where A7:A3000 = C7 and also B7:B3000 = 01/01/2006

Thanks

Andy


--
Andyd74
------------------------------------------------------------------------
Andyd74's Profile:
http://www.excelforum.com/member.php...o&userid=34013
View this thread: http://www.excelforum.com/showthread...hreadid=545016