# 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

Tags:

• ✭✭✭✭✭✭

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

I would suggest a SUMIFS.

• ✭✭✭

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.

• ✭✭✭✭✭✭

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭

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

• ✭✭✭✭✭✭

Excellent!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!