OR in SUMIF function

Hello,

I am trying to use OR in SUMIF function as below but get invalid operation error:

=SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]83) + SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]84)

Find more posts tagged with

Accepted answers

All comments

Sharareh Zand

Sorry, below if the formula I use:

=SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, OR(({Confidence Level} = [Column11]84), ({Confidence Level} = [Column11]84)))

Paul Newcome

I am seeing a lot of different row numbers scattered throughout the formulas.

In your first formula you have

And in your second you have

Each across different columns. Can you verify that these formulas are referencing different rows?

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.