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
I have made some progress. Go to Data, subtotals and by choosing which columns I wanted added with which column breaks I have managed to add them. Its great! Now how do I sort it to work out the top 5?
|