Column Totals For Individual Pages

[T Tran]

Is there a way to have column totals for each page?

I have two columns that I total up using "SUM(A:A)".

For printouts, however, I would like to have each page display it's summary
for column A. It would be even nicer to have it displayed in the footer!

Any ideas?

 

[Gord Dibben]

=SUM(A:A) sums only one column so I assume you also have a formula for the
other column.

First....is there any criterion(a) on which you could use the Data>Subtotal
function to insert a subtotal with a pagebreak at each subtotal?

If not, you will have to place =SUM(Ax:Axx) every 55 rows then enter a
manual pagebreak below that row.

Someone may come up with some VBA code to place a subtotal above each
pagebreak.

You would need VBA to place the subtotal in the footer.


Gord Dibben MS Excel MVP