View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PGibson PGibson is offline
external usenet poster
 
Posts: 4
Default Double Subtotal Problem {Excel 2000}

I am trying to subtotal "at each change in" column 1 and then I do a new subtotal "at each change in" column 2 and uncheck "replace current subtotals" if there are 10 or more rows everything is fine. If there are less than 9 rows, the "Summary below data" rows are switched on the last subtotal. Is this a known bug or just something that I have yet to figure out?

Correct (10 rows):
Species STGSort
POPLAR 4/4 FAS
POPLAR
RED OAK 15/16" 4/4 1C SOU
RED OAK 15/16" 4/4 2C
RED OAK 15/16" 4/4 FAS RED
RED OAK 15/16" 4/4 FAS SOU
RED OAK 15/16"
SOFT MAPLE 15/16" 4/4 FAS RED
SOFT MAPLE 15/16" 4/4 FAS SOU
SOFT MAPLE 15/16" 4/4 SEL/BTR WHITE
SOFT MAPLE 15/16"
Grand
Grand

Incorrect (9 original rows):
Species STGSort
POPLAR 4/4 FAS
POPLAR
RED OAK 15/16" 4/4 1C SOU
RED OAK 15/16" 4/4 2C
RED OAK 15/16" 4/4 FAS RED
RED OAK 15/16" 4/4 FAS SOU
RED OAK 15/16"
SOFT MAPLE 15/16" 4/4 FAS RED
SOFT MAPLE 15/16" 4/4 FAS SOU
SOFT MAPLE 15/16"
SOFT MAPLE 15/16" 4/4 SEL/BTR WHITE
Grand
Grand