Using SumIFS and OR

Hi All,

I am having some syntax issue that I can't get around. I have the following formula referencing a separate sheet.

=SUMIFS({Closed Transaction Qty}, {Closed Line Category}, [Item Category]@row, {Closed Line Del.Yr}, Year@row, {Delivered Month}, [Month #]@row, OR({Load Dock Ind.}, ="A", {Load Dock Ind.}, ="NOS"))

It returns 'invalid data'.

What I am trying to sum the 'qty' column based on;

- the specific category@row

-Month@row

-Year@row

- load Dock Ind. = A or NOS

All looks good when I don't try to use the OR function. I.e., I stop with Load Dock Ind.=A. However, I am having an issue when I try to add the second condition of 'Load Dock Ind.=NOS'. It has to be the order I am using?

Mike R.

Find more posts tagged with

Formulas

Accepted answers

Leibel S

@Michael Rodriguez

Below is the formula changed for using an OR condition.

=SUMIFS({Closed Transaction Qty}, {Closed Line Category}, [Item Category]@row, {Closed Line Del.Yr}, Year@row, {Delivered Month}, [Month #]@row, {Load Dock Ind.}, OR(@cell ="A", @cell ="NOS"))

All comments

Leibel S

@Michael Rodriguez

Below is the formula changed for using an OR condition.

=SUMIFS({Closed Transaction Qty}, {Closed Line Category}, [Item Category]@row, {Closed Line Del.Yr}, Year@row, {Delivered Month}, [Month #]@row, {Load Dock Ind.}, OR(@cell ="A", @cell ="NOS"))

Michael Rodriguez

Thanks that worked. I know was missing something..

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.