Count Multiple Criteria

I'm trying to count a number of different items with multiple criteria.

This is how I currently have it :

=SUM(COUNTIF(Department:Department, "03 AACA Finance") + (COUNTIF(Department:Department, "03 AANJ Finance

e")))

Is there an easier way since SS doesn't do arrays or do I need to keep adding the COUNTIF to the formula for each criteria?

Find more posts tagged with

Formulas

functionality

Accepted answers

L_123

Smartsheet can handle arrays, a couple examples of array formulas are collect() and distinct(). That said you don't need to handle arrays for this formula.

COUNTIF(Department:Department, or(@cell = "03 AACA Finance", @cell = "03 AANJ Finance"))

All comments

L_123

Smartsheet can handle arrays, a couple examples of array formulas are collect() and distinct(). That said you don't need to handle arrays for this formula.

COUNTIF(Department:Department, or(@cell = "03 AACA Finance", @cell = "03 AANJ Finance"))

Richard Lucas

That worked great! Thank you.

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.