Trouble gathering a SUM from another sheet.

Miguel P · 2025-07-29T17:22:38+00:00

There was an error rendering this rich post.

I've been running into an issue where I have a sheet that gathers all information from a form. Im trying to gather a sum of a total of a column, but only reference the values of specific rows that from column.
Example: I have Column to indicate "fixture color" that will be a specified by the form. I want to sum another column that shows qtys for both, but only want to have it show "silver" counts into another sheet.

Ive been trying to use =Sumif(criteron, value,[sumg_range]),
When I've selected the column for criterion, and sum range but the formula comes back as unparseable.

Find more posts tagged with

Formulas

SumIfs

Accepted answers

All comments

Paul Newcome

My apologies. You also need quotes around "Silver".

Miguel P

I redid the formula without the [ and it still comes back as Unparseable.

Do need to be selecting specifc cells when im liking it because i am just selecting the column.

Paul Newcome

Start with removing the opening square bracket [ from before the last range.

jjg279

Hey Miguel! In the screenshot about you have an extra "[" after Silver. It should read:

=SUMIF({Nashua Inventory Sheet Meta Data Range}, Silver, {Nashua Inventory Sheet Meta Data Range 2})

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.