Sheet summary formula

Options

I have several status for work in progress. They are very detailed and granular (not started, writing in progress, review 1, revisions 1, review 2, revisions 2, editorial, final review, ready for client). I would like to create a sheet summary that counts several of these statuses together (example: grouping writing in progress, review 1, revisions 1).

Is it possible to group these into one formula for the sheet summary?

How would I modify the basic formula: =COUNTIF(Status5:Status13, "Writing in Progress")

Thank you.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!