How to do calculation rather than just COUNTIFS or SUMIFS



I have a table like a inventory with all goods with unit price. Such as:

A1 A 100 $5.00

B1 B 200 $10.00

A2 A 150 $7.00

B2 B 50 $12.00

C1 C 80 $20.00

If I want to count how many "A" I have now, I can use COUNTIF(A).

My challenge is, I need to calculate the total price of all goods under category A, like:

=SUMIF(amount*price, category, ="A").

I know SUMIF or SUMIFS can only add up all numbers match the condition, does Smartsheet support my scenario where I want to do calculation rather than simply adding up all number?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!