COUNTIFS using criteria from both column A and B

Copper Contributor

I can't figure out how to combine the formulas =COUNTIF(B:B,"IHC*")+COUNTIF(B:B,"SS*") and =COUNTIFS(A:A,">1330",A:A,"<1431")

 

I want to only count the criteria in column A if the criteria in column B is also met.

 

Thank you,

5 Replies
Hi Anna,

You probably need to do 2 COUNTIFS given you want to count IHC* or SS*

=COUNTIFS(A:A,">1330",A:A,"<1431",B:B,"IHC*") + COUNTIFS(A:A,">1330",A:A,"<1431",B:B,"SS*")

Or bit more compact =SUM(COUNTIFS(B:B,{"SS*";"IHC*"},A:A,">1330",A:A,"<1431"))

Thank you, it worked!

Thank you! I don't understand this one, but it gave me the same result as above! Smiley Happy

Anna, that is the imitation of OR condition. In brief, COUNTIFS on array of conditions also generates an array, after that you just take the sum of it. Like SUM({5,7})=12