Sales by category formula

clewis_10990

I am new to Smartsheets and trying to create a formula that will allow me to show sales per product category. I want to show sales to date for multi family, for single family, for commercial etc. How can I do this?

KPH

Hi @clewis_10990

You can do this using a SUMIF formula.

I can't see your column names in the screen shot but for Single Family it would be something like:

=SUMIF(Category:Category, "Single Family", Sales:Sales)

If your columns are called Category and Sales.

KPH

😊 Thank you @clewis_10990 , happy to help.

Please click “yes” next to Did this answer the question?  on the answer, so others can find the solution easily.

KPH

Hi @clewis_10990

You can do this using a SUMIF formula.

I can't see your column names in the screen shot but for Single Family it would be something like:

=SUMIF(Category:Category, "Single Family", Sales:Sales)

If your columns are called Category and Sales.

clewis_10990

You are a lifesaver, KPH! Thank you so much!!

KPH

😊 Thank you @clewis_10990 , happy to help.

Please click “yes” next to Did this answer the question?  on the answer, so others can find the solution easily.