COIUNTIFS as an OR

Is their a way to use the COUNTIFS as an OR.

Currently, it will count all conditions of a cell that match the conditions given.

=COUNTIFS([Clothing Item]:[Clothing Item], "Jacket", [In Stock?]:[In Stock?], 1) will give me the count of all "Jackets" that are "In Stock"

However, I am looking to count if [Clothing Item]:[Clothing Item] is either a "Jacket" or a "Blouse".

Find more posts tagged with

Formulas

Accepted answers

All comments

jmyzk_cloudsmart_jp

Hi @rwcanary99

You can use OR(@cell="Jacket",@cell="Blouse"). Or you can just add with +.

In Stock and Jacket or Blouse

=COUNTIFS([In Stock]:[In Stock], 1, [Clothing Item]:[Clothing Item], OR(@cell = "Blouse", @cell = "Jacket"))
=COUNTIFS([In Stock]:[In Stock], 1, [Clothing Item]:[Clothing Item], "Jacket") + COUNTIFS([In Stock]:[In Stock], 1, [Clothing Item]:[Clothing Item], "Blouse")

Jacket or Blouse

=COUNTIFS([Clothing Item]:[Clothing Item], OR(@cell = "Jacket", @cell = "Blouse"))
=COUNTIFS([Clothing Item]:[Clothing Item], "Jacket") + COUNTIFS([Clothing Item]:[Clothing Item], "Blouse")

https://app.smartsheet.com/b/publish?EQBCT=e1d82ccbb5b54a9ba6763a034bcef847

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.