| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal twice
Original data:
Vendor Type Amt Vend A Stationery 1 Vend A Stationery 2 Vend A Welfare 3 Vend A Fixture 1 Vend B Stationery 3 Vend B Stationery 2 Vend B Fixture 1 Vend B Fixture 2 Required to get (1) Individual Vendor Total and (2) Individual Type Total Question: How to achieve the following result using Subtotal? Vendor Type Amt Vend A Stationery 1 Vend A Stationery 2 Stationery Total 3 Vend A Welfare 3 Welfare Total 3 Vend A Fixture 1 Fixture Total 1 Vend A Total 13 Vend B Stationery 3 Vend B Stationery 2 Stationery Total 5 Vend B Fixture 1 Vend B Fixture 2 Fixture Total 3 Vend B Total 16 Grand Total 30 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
