Sum number of items based by Product Category selected

Question

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 🙏

Alfonso L. · Accepted Answer

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. · Accepted Answer

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