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

Anthony S.

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)

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)

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