Using COUNTIF/COUNTIFS with OR statements

jcasorla1

If I want to do a row count, where if Col1= 4 or 5 OR Col2 = 4 or 5, what is the best way to go about this? So for the example below, the count is 3.

Appreciate any help. Thank you.

JamesB

@jcasorla1

Create a helper column with the following formula.

=IF(AND(OR([Col1]@row = 4, [Col1]@row = 5), OR([Col2]@row = 4, [Col2]@row = 5)), 1, 0)

Then you can count up the number of occurrences of the number 1.