SUM IF with OR Criteria throwing Invalid Operation error-what are we missing?

I am trying to count a number meeting hours for each leader, but only meetings they lead or are mandatory to attend. I have been trying to get this to work for those 2 types of 'status' and I must missing a nuance somewhere. Thanks!

=SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, "JG", (OR(Status:Status = "Mandatory", Status:Status = "Leader")))

Find more posts tagged with

Formulas

Accepted answers

Dan W

Give this a try

=SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, "JG", status:status, OR(@cell = "Mandatory", @cell = "Leader"))

Razetto

Have you tried using @ cell? I wonder if splitting the formula helps out:

=SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, @cell = "JG", Status:Status, @cell = "Mandatory") + SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, @cell = "JG", Status:Status, @cell = "Leader")

All comments

Dan W

Give this a try

=SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, "JG", status:status, OR(@cell = "Mandatory", @cell = "Leader"))

Razetto

Have you tried using @ cell? I wonder if splitting the formula helps out:

Tina Rustvold

Thank you @Razetto and @Dan W! The @cell was the answer! So many things to remember it's great to have other brains to utilize. 😄 Have a great day!

Dan W

@Tina Rustvold Happy to 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.