Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Freddy
 
Posts: n/a
Default 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   Report Post  
RagDyer
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multi group with summary above with 1 overall summary line below Freddy Excel Discussion (Misc queries) 2 November 7th 05 04:30 PM
Converting a group of lines into one line without merging THEFALLGUY Excel Discussion (Misc queries) 2 August 24th 05 06:45 PM
have a summary sheet that needs to link to every ten line on the . Bruner Excel Worksheet Functions 1 February 9th 05 10:30 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 02:46 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM


All times are GMT +1. The time now is 12:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"