Sorting data and Advance filtering to get totals on a spreadsheet

[Pinlaro]

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

 

[Pinlaro]

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

Total sales units to be added are 37 and 29

Total sales value to be added is 3035.70 and 2535.1
Hope it makes sense

 

[Luke M]

Easiest way would be to build a PivotTable.
Use Codes as your row, and Sales and Units as your data.

 

[Pinlaro]

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?

 

[Pinlaro]

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!