I am having trouble using "And", "OR" & "Countif(s)" to build a formula.

Hello,

I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5 different statuses in a separate column.

So using the screenshot I've provided as an example (although it doesn't have 5 different statuses in the same column) I would like a sheet summary formula that says =COUNTIF([Item Number]:[Item Number], "C001" OR "COO2" OR "COO3" OR "COO4" AND Status:Status, "Green" OR "Yellow" OR "Red"

My apologies in advance if I worded this question in a less than optimal manner.

Screenshot 2023-08-25 154417.png

Find more posts tagged with

Formulas

Accepted answers

Carson Penticuff

Try this:

=COUNTIFS([Item Number]:[Item Number], OR(@cell = "C001", @cell = "COO2", @cell = "COO3", @cell = "COO4"), [Status]:[Status], OR(@cell = "Green", @cell = "Yellow", @cell = "Red"))

All comments

Carson Penticuff

Try this:

=COUNTIFS([Item Number]:[Item Number], OR(@cell = "C001", @cell = "COO2", @cell = "COO3", @cell = "COO4"), [Status]:[Status], OR(@cell = "Green", @cell = "Yellow", @cell = "Red"))

SmarsheetNewb

Thank you so much! I was able to use your response to figure out exactly what I needed to do!

Carson Penticuff

👍

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.