counting with multiple criteria
 

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

counting with multiple criteria
 

Try this

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


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

counting with multiple criteria
 

=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

counting with multiple criteria
 

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.

"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