Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
making subtotals and grandtotal from multiple pages excel2000
i have made excel worksheet, it consist of 15 pages.
i need to total each page add all subtotals to make grandtotal on final page how do i incorporate subtotals of each page to final page?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
making subtotals and grandtotal from multiple pages excel2000
You are looking for a database/reporting tool functionality. It can be done
manually in Excel, but you'll have to be very careful with page breaks Go into ViewPage Break Preview. Starting at the top of the print range scroll down to the first page break. Insert a row (or rows, if you prefer) ABOVE THE page break. In the columns you want subtotaled use the SUBTOTAL(9,range) function. The range to SUBTOTAL starts with the first row of data and ends with the last row on this first page Now repeat for each of the page breaks. However, the range to subtotal can be EITHER the range of rows printing on the relevant page, or it can be all the rows from the very top down to the last row on the relevant page. For the grand total you'll again use the SUBTOTAL(9,...) function, but this time use the entire column of data "brhexcel" wrote: i have made excel worksheet, it consist of 15 pages. i need to total each page add all subtotals to make grandtotal on final page how do i incorporate subtotals of each page to final page?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|