Sorting data and Advance filtering to get totals on a spreadsheet
Easiest way would be to build a PivotTable.
Use Codes as your row, and Sales and Units as your data.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Pinlaro" wrote:
Hi there
Hope you can help me please. I have to add up totals in Column C and Column
D but only for lines with the same code in Column A. For example: how many
units of code 1138578 have I sold and what was the total sales value for that
code. Usually I would just do it one by one using sort and autosum but I have
a list with 2000 codes. Please help.
Code Description Total Sales Units Total Sales Value
1138570 Lc Cast Iron 1 7.10
1138578 Lc Cast Iron 114 6,137.6
1138582 Lc Cast Iron 37 3,035.7
1138582 Lc Cast Iron 29 2,535.1
|