Sum Values in the Range of the Cells

Nikita Che

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

Andrée Starå

Hi @Nikita Che

I hope you're well and safe!

Try something like this.

=SUMIFS(Quantity:Quantity, Order:Order, 1)

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

I would suggest a SUMIFS.

https://help.smartsheet.com/function/sumifs

Nikita Che

Hi Paul! Thank you! In my case, there are several lines with the same Order number. I want to sum up these lines. Where in the SUMIF I can set this condition to sum the quantity of the items belonging only to one order.

Andrée Starå

Hi @Nikita Che

I hope you're well and safe!

Try something like this.

=SUMIFS(Quantity:Quantity, Order:Order, 1)

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Nikita Che

Andree, good to see your comment! You have set me on the right course: my formula in Excel looks like this:

and in the Smartsheet, I have added @row

Thank you, this has solved my issue

Andrée Starå

@Nikita Che

Excellent!

Happy to help!