Maybe you could try something like this:

If the UNITS are in Col_B and the AMOUNTS are in Col_C

F1: OH
F2: Sold
F3: WSS

G1: =SUMIF(B:B,F1,C:C)
Copy that formula down through G3

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

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