MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sum at the end of each page

Posted by Page sum on April 23, 2001 9:20 PM

Is it possible to create a cumulative sum at the beginning and at the end of each page automatically? I have a long list of values and I'd like to create something like this:

Item 1 $567
Item 2 $666
Total sum of this page: $xxx
--- Page break ---
Cumulative sum from previous pages: $yyy
Item 123: $555
Item 124: $666
Total sum of this page: $zzz
--- Page Break ---

Since the list is quite long, I'd like to avoid manual work.


Posted by Dave Hawley on April 23, 2001 9:47 PM

Hi Francisco

Have you had a look at Subtotals. This can be found under Data on the main Menu. Or perhaps even a Pivot table, also found under Data.

With a Pivot Table you may be better of using a Dynamic range for the source data. You can see some examples of these on my Website under "Dyanamic Ranges"


OzGrid Business Applications