BaffledOfBristol
New Member
- Joined
- Dec 24, 2013
- Messages
- 13
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
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