Sales by category formula

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?

Best Answers

  • KPH
    KPH ✭✭✭✭✭✭
    Answer βœ“

    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
    KPH ✭✭✭✭✭✭
    Answer βœ“

    😊 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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!