Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
Converting a group of lines into one line without merging | Excel Discussion (Misc queries) | |||
have a summary sheet that needs to link to every ten line on the . | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
pivot table multi line chart | Charts and Charting in Excel |