Sheet summary formula

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.

Find more posts tagged with

Accepted answers

All comments

hollyconradsmith

Hi @AnneSophie ,

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.