Sheet Summary Field: COUNTIFS formula with multiple OR

Hello,

Looking for some help with a formula I would like to add as a sheet summary field for a report which will be used in a dashboard chart. I have used this formula before with other sheets (different columns and values) but it is not working in this sheet. This is the formula which I cannot figure out how to fix:

sheet summary field: Count Open IT Issues

=COUNTIFS([Status Text]:[Status Text], OR (@cell= "Active", @cell = "Triage"), [Resolution]: [Resolution], OR (@cell= "Data", @cell= "Bug", @cell= "Incident", @cell= "Access"))

I will be creating this chart. In this one example, I need to isolate the open IT Issues. So the formula should look at the Status column as well as the Resolution Type column to determine whether to count the row or not.

Please help! Thanks in advance.

--Lisa

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Lisa Matthews2

It looks like you might have an extra space after each OR but before its opening parentheses...ex:

OR (

instead of

OR(

Can you check to make sure that there are no gaps between a function and its parentheses?

=COUNTIFS([Status Text]:[Status Text], OR(@cell= "Active", @cell = "Triage"), [Resolution]: [Resolution], OR(@cell= "Data", @cell= "Bug", @cell= "Incident", @cell= "Access"))

Paul, let me know if I'm missing something else 😉

All comments

Paul Newcome

Are you getting an error or an incorrect count?

Lisa Matthews2

Hi Paul,

I am getting a "unparseable" message.

Thank you for taking a look at this.

--Lisa

Genevieve P.

Hi @Lisa Matthews2

It looks like you might have an extra space after each OR but before its opening parentheses...ex:

OR (

instead of

OR(

Can you check to make sure that there are no gaps between a function and its parentheses?

=COUNTIFS([Status Text]:[Status Text], OR(@cell= "Active", @cell = "Triage"), [Resolution]: [Resolution], OR(@cell= "Data", @cell= "Bug", @cell= "Incident", @cell= "Access"))

Paul, let me know if I'm missing something else 😉

Lisa Matthews2

Hi Genevieve!

That's what it was! It's fixed now! Kicking myself for missing that, but grateful and happy to have help!!

Thank you so much! Hope you have a great day :)

--Lisa

Genevieve P.

Thanks for letting me know that worked! I hope you have a great day as well. 🙂

Paul Newcome

@Genevieve P. That's exactly what I was looking at but couldn't remember if that would throw an error or not.

Lisa Matthews2

@Paul Newcome @Genevieve P.

thank you both for your help! :)

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.