Count if for multiple columns

Hi all,

I'm trying to create a count if formula to find data in two columns.

For instance I have two columns. One column is status and the other is for discipline.

I am trying to count if the status is "complete" and the discipline is "marketing". I need the formula to tell me what is the total count in the Smartsheet. Anyone have a formula I could use? Is the "Count If" the right formula to use for this?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

You actually want the COUNTIFS (with the S on the end) to incorporate more than 1 range/criteria set.

=COUNTIFS(Status:Status, "Complete", Discipline:Discipline, "Marketing")

Nicolette Thomas

THIS WORKS! Thank you so much!

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.