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

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

Find more posts tagged with

Accepted answers

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

All comments

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 🙂

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.