Originally Posted by pete212

Hello,I'm not sure if this is in the right forum, apologies if not. I couldn't see a general formular help section.
I have some data and need to do a COUNTIF but based on two seperate conditions. I need it to count items only if there is a "3" in column J AND a "7200" in column B.
I've tried using the following:
COUNTIF(QBR!B:B,7200)+COUNTIF(QBR!J:J,3)
However this adds the total of "7200"s and the total of "3"s, regardless if they 'match' in the same row.
I also tried: COUNTIF(QBR!B:B,7200)AND*(QBR!J:J,3)
with no luck and:SUMPRODUCT((QBR!B:B="7200")*(QBR!J:J="3"))
But this just returns 0, not sure why.
Does anyone have any ideas on how to get this working?
Many thanks for any help you can offer.