Using COUNTIF/COUNTIFS with OR statements

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
    JamesB ✭✭✭✭✭✭
    edited 03/11/24


    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!