Sum Values in the Range of the Cells

Dear Colleagues,

I have a list of products and their quantity. Several lines can belong to the same order. My task is to sum up all the values in the "Quantity" column if the value of the "Order Number" is the same. Which formula would you recommend I use?

Order | Product | Quantity | Sum of Quantity

O1 | ABC | 10 | 11

O1 | XYZ | 1 | 11

O2 |123P | 25 | 45

O2 |XYZ | 20 | 45


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!