Using SumIFS and OR

Michael Rodriguez

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.

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"))

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..