Countifs OR Formula Issues

I am doing a countifs formula, and am unsure how to include an OR formula.

In the Summary Program column located on another sheet, I want it to count the number of both Bi-Annual and EMEA cells. for rows which Summary Season is S21 This is the formula I have used that resulted in an Invalid Operation error.

=COUNTIFS({Summary Season}, "S21", {Summary Program}, OR("Bi-Annual", "EMEA"))

The Season and Program columns are located on another smartsheet, and the references are correct. Below is a sample of the two columns. I would like the formula to look at this and total it to 6.



Tags:

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Hello,

    Try:

    =COUNTIFS({Summary Season}, "S21", {Summary Program}, OR(@cell="Bi-Annual", @cell="EMEA"))

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!