multi group with summary above with 1 overall summary line below
 

Is it possible to setup, on a given spreadsheet, groups so that 4 or 5
categories (for example) are summarized with the (bolded) title line above
the detail for each section but with the overall summary line for the
spreadsheet (i.e. the "bottom line") appears at the bottom of the sheet;

or, in other words, change the setting of the groupings to be different on
the same sheet?

multi group with summary above with 1 overall summary line below
 

Insert a row and link it to the original total row at the bottom of the
sheet.

Insert a row at the location you wish.
Enter an equal sign ( = ) in the particular cell in this new row,
Navigate to, and click in, the total cell at the bottom,
Then hit <Enter.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Freddy" wrote in message
...
Is it possible to setup, on a given spreadsheet, groups so that 4 or 5
categories (for example) are summarized with the (bolded) title line above
the detail for each section but with the overall summary line for the
spreadsheet (i.e. the "bottom line") appears at the bottom of the sheet;

or, in other words, change the setting of the groupings to be different on
the same sheet?