COUNT multiple ranges

S

_Scott_

Hi Guys

This formlua has has me stumped, what I am trying to do is...

IF the data in column B equals say POP & the data in Column C equals JOP
that entry receives a count (both entries must be on the same row to receive
a count)


example data
A B C D E
1 POP JOP
2 PPP JOP
3 POP GUP
4 POP JOP
5 YUP KUP
6 POP JOP

So the above table would return the count of 3

any help will be appreciated
 
B

Bob Phillips

=SUMPRODUCT(--(B1:B6="POP"),--(C1:C6="JOP"))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
S

_Scott_

Thanks for that works brilliantly
Bob Phillips said:
=SUMPRODUCT(--(B1:B6="POP"),--(C1:C6="JOP"))

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
Top