Sumifs with range


Refer to below, trying to get total sum of certain items.

Scenario : Sum numbers from the column, Color, if the column, Fruit is "Apple".

I tried below, but returning error. Please help.

=SUMIFS([color]99:[color]104), fruit99:fruit104, "Apple")

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!