How do I solve this UNPARSEABLE error for a cross-sheet SUMIFS formula?

I'm attempting to sum a column in another sheet based on matching the product name, the month, and the vendor values in the current sheet but I can't seem to resolve the UNPARSEABLE error. What am I missing?

=SUMIFS({Quantity}, {Product}, Product$1, {Month}, Month$1, {Vendor}, Vendor$1)

Find more posts tagged with

Accepted answers

Monique Odom Stearn

Hello @Anthony S.,

I believe you need to put brackets around your column references, so the updated formula would be:

=SUMIFS({Quantity}, {Product}, [Product]$1, {Month}, [Month]$1, {Vendor}, [Vendor]$1)

All comments

Monique Odom Stearn

Hello @Anthony S.,

I believe you need to put brackets around your column references, so the updated formula would be:

=SUMIFS({Quantity}, {Product}, [Product]$1, {Month}, [Month]$1, {Vendor}, [Vendor]$1)

Anthony S.

Hi @Monique_Odom_Comcast,

Thank you! I already tried that before and again now to be sure but that unfortunately does not resolve the error message.

Anthony S.

Monique_Odom_Comcast, actually you were right! I just realized that I had two column names mis-referenced. Thanks!!!!

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.