How to do calculation rather than just COUNTIFS or SUMIFS

Options

Hi,

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?


Thanks,

Danmu

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!