Count Formula for more than one condition

Options
This discussion was created from comments split from: Count Formula for more than one condition.

Answers

  • Eckh1
    Eckh1 ✭✭
    Options

    Hello, i want to count more than word in a row like, Incorrect, Incomplete and missing.

    This formula works perfectly for one word, how do i add two more @cell?

    =COUNTIF([Account Number]@row:[X-code]@row, CONTAINS("Incorrect", @cell))

     

    Does anyone have an idea how to get this to work?

    Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!