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
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
Try this
=sumproduct(--(a7:a3000=c7),--(b7:b3000="01/01/2006"+0))
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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
=SUMPRODUCT(--(A7:A3000="C7"),--(B2:B3000=--"2006-01-01"))
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"Andyd74" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks