Sheet summary formula

AnneSophie

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.

hollyconradsmith

Hi @AnneSophie ,

You can use "Countifs" to apply multiple criteria. https://help.smartsheet.com/function/countifs