Sum number of items based by Product Category selected

Options

Hello:

I am creating a Purchase management based in the template loans.

I just use one sheet

_Small Business Request Intake Sheet

it has these columns


So in the sheet

📌 Purchases Metrics (Do Not Edit)

I am creating a column called "Total units" based in the purchase category that show me the number of units are requested by Category, for instance in the image above we have 3 Chromebooks "in Review" and 2 Chromebooks "not reviewed", So I would like that to sum both quantities based in the Category Chromebooks Quantities 5.


At this moment I am using this Formula.✎

=SUM({Small Business Request Intake Sheet quantity}, [Data Points]@row, {Small Business Request Intake Sheet Category}, [Data Points]@row)

I am totally blocked!!! 🙈


PD: if is not ask to much please could you help me too to show "Total units Not Reviewed" to show for instance 2 Chromebooks?



❤ Thank you so much 🙏

Best Answers

  • Alfonso L.
    edited 10/27/20 Answer ✓
    Options

    Just for those who need this formula also: Support helped me.

    =SUMIF({Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Intake Sheet quantity})

    how to add second criteria to the formula.

     to sum the quantity based First in the IT category and also in the status of the requests I am trying this one.

    =SUMIF({Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Sheet Review Status}, "On Hold", {Small Business Request Intake Sheet quantity})) 

    I need help to add a second condition by category and by review status...any Idea?

  • Alfonso L.
    Answer ✓
    Options

    Ok, once again support helped me to find the solution:

    =SUMIFS({Small Business Request Intake Sheet quantity},{Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Sheet Review Status}, "On Hold" )


    thank you smartsheet support

Answers

  • Alfonso L.
    edited 10/27/20 Answer ✓
    Options

    Just for those who need this formula also: Support helped me.

    =SUMIF({Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Intake Sheet quantity})

    how to add second criteria to the formula.

     to sum the quantity based First in the IT category and also in the status of the requests I am trying this one.

    =SUMIF({Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Sheet Review Status}, "On Hold", {Small Business Request Intake Sheet quantity})) 

    I need help to add a second condition by category and by review status...any Idea?

  • Alfonso L.
    Answer ✓
    Options

    Ok, once again support helped me to find the solution:

    =SUMIFS({Small Business Request Intake Sheet quantity},{Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Sheet Review Status}, "On Hold" )


    thank you smartsheet support

  • Alfonso L.
    edited 10/27/20
    Options

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!