| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal twice
Select your table and click Data/Subtotal at each change in Vendor, use
function Sum on Amt column. Repeat for each change in Type, use function Sum on Amt column (and uncheck the box that says "Replace current subtotals"). Be sure your table is sorted/grouped by vendor and type before subtotaling. "Michelle" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
