Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is it possible to subtotal every third row? I have the following type
of spreadsheet: Group Style Units B FENDI MEDIUM CHAIN BAG OH 0 B FENDI MEDIUM CHAIN BAG Sold 1 B FENDI MEDIUM CHAIN BAG Wss 0 B FENDI LARGE CHAIN BAG OH 1 B FENDI LARGE CHAIN BAG Sold 0 B FENDI LARGE CHAIN BAG WSS 0 B FENDI MEDIUM CHAIN BAG OH 1 B FENDI MEDIUM CHAIN BAG Sold 0 B FENDI MEDIUM CHAIN BAG WSS 0 Basically, I need subtotals by Group, as well as a couple of other columns that I couldn't show in this form (this is a huuuuge spreadsheet). I need the subtotals to add up the OH, Sold, and WSS-- Is this possible? I'm guessing it is, I'm just starting to realize what an amazing program Excel is (once you master it)! I thought my pivot table and V-Lookup skills were impressive, but apparently there is a whole world of custom lists, VBA etc that I haven't even begun to touch...Thank you soooooo much for your help, you can't even begin to understand how much your advice will help! Best, Danielle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotaling of hours | Excel Worksheet Functions | |||
Subtotaling problem | Excel Discussion (Misc queries) | |||
Sorting after subtotaling | Excel Discussion (Misc queries) | |||
Sorting after subtotaling | Excel Worksheet Functions | |||
Slow Subtotaling | Excel Discussion (Misc queries) |