Counting Item that meets Criteria.

Good Evening Community. Trying to count an item that meets certain criteria. For example I am referencing two columns of the same sheet and trying to count the first column that contains Food POS and has a Projected Status of Projected Install. Below is code that has been attempted.

=COUNTIF(AND(({POS Install Status}, "Food POS") {POS Projected Install}, "Projected Installed"))

Find more posts tagged with

Formulas

Accepted answers

All comments

Kerry St. Thomas

COUNTIF doesn't play nice with AND. Instead, try COUNTIFS (plural). This formula basically is the same logic as the "AND" you're trying to capture.

=COUNTIFS({POS Install Status},"Food POS",{POS Projected Install}, "Projected Installed")

Check this out for more information about COUNTIFS:
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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.