COUNT multiple ranges

[_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

 

[Bob Phillips]

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

--

HTH

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

 

[_Scott_]

Thanks for that works brilliantly

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

--

HTH

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

 

[Excelders]

are you just counting the POP-JOP combination or would JOP-POP be valid
too?