Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summarising a List of Data
I am trying to partially summarise a list of costs so that all costs over a
certain amount cost are shown in detail while all other costs are grouped together as "others". for example repair to ac 30,000 repair to roof 14,000 new table 500 new chairs 450 Cleaning costs 200 Total 45,150 Would show as repair to ac 30,000 repair to roof 14,000 others 1150 Total 45,150 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Val list Excel 97 fire macro | Excel Discussion (Misc queries) | |||
Expanding Data validation from List | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) |