Count if criteria in one column is met or criteria in another column is met

[HadenSteward]

Hello,

I'm so sorry if this has been answered but when I try to search for an answer I am really only finding the =COUNTIF(A2:A5,{"Red","Blue","Green"}) kind of answer, which isn't what I need.

I want to do something that gives me a count if a criteria is met in one column OR a criteria is met in another column. I know I can achieve this by creating another row in my data with an IF(OR( and then counting that new column, but I'd rather not do that if I don't have to.

So for this example, I want a count of rows where A column is less than 25 OR B column is less than 3. The result should be 4 because only row 5 fails to meet at least one of these criteria.

Appreciate any help on how to do this.

Thanks,

Haden Steward

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUM(SIGN((A1:A5<25)+(B1:B5<3)))

 

[HadenSteward]

Hi & welcome to MrExcel.
How about

=SUM(SIGN((A1:A5<25)+(B1:B5<3)))

Hi, and thank you for welcoming me.
That seems to be giving me the result of 3 but I am looking for the result of 4 because in my example, there is at least one of the two criteria met for rows 1-4.

Thanks!

 

[Fluff]

You have > signs rather than <

 

[HadenSteward]

You have > signs rather than <

Omg you are the best! I do unfortunately and carelessly make that mistake from time to time. :'( Thank you so much! Have an amazing day!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[awoohaw]

Hi & welcome to MrExcel.
How about

=SUM(SIGN((A1:A5<25)+(B1:B5<3)))

I really enjoy your knowledge of functions I seldom use, @Fluff !!!