Hi Danielle

Set up your Pivot Table.
Drag Group to the Row area, drag Style to the row area, drag Units to
the data area and ensure it is set to Sum.
Double click on Group and ensure Subtotals is et to Automatic.

--
Regards

Roger Govier


wrote in message
oups.com...
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