SUMIFS AND Formula Help

Shelby Wilder

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)

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,

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