SUM totals from multiple rows into one row per order

[BaffledOfBristol]

Can anyone help please?

I have a sheet which has multiple cost rows for a single order i.e.:-

ORDER_NO ORDER_TOTAL
OR000123 1000.50
OR000123 723.87
OR000123 145.67
OR000125 1450.84
OR000126 84.23
OR000126 112.45

I would like to create a new sheet which has 1 row per order and the ORDER_TOTAL values summed into one ultimate total column.

Can anyone please confirm the best way to do this?

Many thanks,

BoB

 

[VBA Geek]

this will help you >> SUMIF - Excel - Office.com

 

[BaffledOfBristol]

Hi VBA Geek,

The problem with using SUMIF is that I do not have a criteria i.e. 32, "32", ">32", or "apples". I need excel to be cleaver enough to SUM the totals were the ORDER_NOs are the same.

Thanks

 

[VBA Geek]

copy all of your order no into a new sheet then select the pasted values and remove duplicates, afterwards use each unique order no as a criteria for your SUMIF

 

[mashhood]

hi,

select all your data and simply make a pivot table. It can then be used to sum all the values that have same order numbers. . further details can be found on youtube.

 

[BaffledOfBristol]

Many thanks mashhood, pivot table worked a treat!

 

[mashhood]

your welcome good to hear that