making subtotals and grandtotal from multiple pages excel2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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 View>Page 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Does Excel have a @grandtotal function like Lotus 123 2
worksheet to worksheet subtotals 4
Sum of each row. 4
summing subtotals 1
multiple subtotals 1
SUBTOTALS in excel2003 differs from excel2000 1
I want to link totals on multiple worksheets into one total 3
subtotal, match? 10

Back
Top