Trouble gathering a SUM from another sheet.

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

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})

Paul Newcome

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

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

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

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.