Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column Totals For Individual Pages
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? :) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column Totals For Individual Pages
=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 DataSubtotal 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 On Thu, 16 Oct 2008 09:45:02 -0700, T Tran wrote: 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? :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding totals on different pages in different workbooks | Excel Worksheet Functions | |||
adding individual cells in a column | Excel Worksheet Functions | |||
Calculating totals in a column based on a lookup in another column | Excel Worksheet Functions | |||
how do i create a journal with individual ledger pages? | Excel Worksheet Functions | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions |