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.