Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting data and Advance filtering to get totals on a spreadsheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need advance filtering to grab records that contain certain charac | Excel Discussion (Misc queries) | |||
advance level of sorting data? by Ting | Excel Worksheet Functions | |||
Sorting/Filtering data ??? | Excel Discussion (Misc queries) | |||
advance filtering | Excel Discussion (Misc queries) | |||
Advance filtering with multiple conditons | Excel Discussion (Misc queries) |