Count Formula for more than one condition

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

Answers

  • Eckh1
    Eckh1 ✭✭

    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!