counting with multiple criteria

[Andyd74]

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

 

[daddylonglegs]

Try this

=sumproduct(--(a7:a3000=c7),--(b7:b3000="01/01/2006"+0))

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Guest]

Hi

Try this:
=SUMPRODUCT(--(A7:A3000=$C$7),--(B7:B3000=DATEVALUE("01/01/2006")))
You have column B twice in your explanation, by the way. I've put it in
once.
I've also assumed that your reference to C7 is absolute.

This is untested.

Hope this helps.
Andy.