Count multiple criteria in a row

edited 12/09/19 in Formulas and Functions

I have spent hours scrolling through all the great advice in the Community, and there is not a formula that is working for me. I need to count all the Semi-Annual Update, In Progress, and Waiting on County in a column.

=COUNTIF([Status Report]:[Status Report], "Semi-Annual Update") works great to count all of the Semi-Annual Update cells, but I can not figure out to get the total of all cells with Semi-Annual Update, In Progress, and Waiting on County. Below is a screenshot of my sheet:

Thank you in advance.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!