| Home |
| Search |
| Today's Posts |
|
#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! |
| 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) | |||
Threaded Mode
