Sorting data and Advance filtering to get totals on a spreadsheet
"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
very easy, highlight what the information you need and sort it!
Job done!
|