I get an #INVALID OPERATION using SUMIFS with multiple criteria referencing a separate sheet.

Devin Barta

I am having trouble getting this formula right.

I want to pull the qty of flooring scheduled to run in a given week (1-52) provided it requires one of 2 types of veneer. (Acacia 1220x077x1.5 or Acacia 1220x185x1.5)

=SUMIFS({Schedule File - 052820 Flooring}, {Schedule File - 052820 Week}, Week@row, {Schedule File - 052820 Veneer}, @cell = "Acacia 1220x077x1.5", OR(@cell = "Acacia 1220x185x1.5"))

Any help is appreciated,

Devin

Genevieve P.

Hi Devin,

You were very close! Try having the OR around the two options though, so it knows what the OR is between:

=SUMIFS({Schedule File - 052820 Flooring}, {Schedule File - 052820 Week}, Week@row, {Schedule File - 052820 Veneer}, OR(@cell = "Acacia 1220x077x1.5", @cell = "Acacia 1220x185x1.5"))

Here's more information on the OR Function: https://help.smartsheet.com/function/or

Let me know if this works for you or not.

Cheers!

Genevieve

Genevieve P.

Hi Devin,

You were very close! Try having the OR around the two options though, so it knows what the OR is between:

=SUMIFS({Schedule File - 052820 Flooring}, {Schedule File - 052820 Week}, Week@row, {Schedule File - 052820 Veneer}, OR(@cell = "Acacia 1220x077x1.5", @cell = "Acacia 1220x185x1.5"))

Here's more information on the OR Function: https://help.smartsheet.com/function/or

Let me know if this works for you or not.

Cheers!

Genevieve

Devin Barta

Thank you very much! This is awesome. I'm still learning the @cell syntax.

Genevieve P.

No worries at all! Glad this worked for you 🙂