Countifs OR Formula Issues

I am doing a countifs formula, and am unsure how to include an OR formula.

In the Summary Program column located on another sheet, I want it to count the number of both Bi-Annual and EMEA cells. for rows which Summary Season is S21 This is the formula I have used that resulted in an Invalid Operation error.

=COUNTIFS({Summary Season}, "S21", {Summary Program}, OR("Bi-Annual", "EMEA"))

The Season and Program columns are located on another smartsheet, and the references are correct. Below is a sample of the two columns. I would like the formula to look at this and total it to 6.

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

Hello,

Try:

=COUNTIFS({Summary Season}, "S21", {Summary Program}, OR(@cell="Bi-Annual", @cell="EMEA"))

Mark

All comments

Mark Cronk

Hello,

Try:

=COUNTIFS({Summary Season}, "S21", {Summary Program}, OR(@cell="Bi-Annual", @cell="EMEA"))

Mark

Shelby Wilder

https://community.smartsheet.com/discussion/comment/295401#Comment_295401

@Mark Cronk That worked! Thank you so much

Mark Cronk

Happy to help. Thank you for contributing to the Community.

Mark

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.