SUMIFS AND Formula Help

Hello, I am attempting to calculate the sum of a PRICE column, if the COLOR column=BLUE AND the FABRIC column=TW100.

If I type =SUMIFS(PRICE, FABRIC, Fabric@row, COLOR, Color@row) it calculates the total for ALL rows in sheet including a BLUE color, even if the FABRIC is not TW100. I need a formula which will only calculate TW100 and BLUE.

The true formula in the sheet is below (it references another sheet)

=SUMIFS({Color Tracking Reporting Range 1}, {Color Tracking Reporting Range 2}, Fabric@row, {Color Tracking Reporting Range 5}, Color@row)

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

Hi Shelby,

Your syntax looks right. Confirm your ranges are linked to the right single columns on your other sheet. The columns need to be text/number or single select. Are the values formulas or hard coded?

Mark

All comments

Mark Cronk

Hi Shelby,

Your syntax looks right. Confirm your ranges are linked to the right single columns on your other sheet. The columns need to be text/number or single select. Are the values formulas or hard coded?

Mark

Mark Cronk

Hi Shelby,

Glad you found the solution. Thank you for using the community.

Mark

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.