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



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


Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!