Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create footer, sum of column values
dear sir ,
i want to create the sum of column(cells values ) like sum( "a3:a end ") at the end of the sheet like footer and to have an perfect print out as detail as detail and totals as report footer |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
create footer, sum of column values
I don't think this could be done without VBA code, and there would be
restrictions even then. You would need the VBA code to create the text of the footer in the _BeforePrint() event. Since any physical sheet can only have one footer, if your sheet extended over multiple printed pages, the footer would only be correct on one of those pages. You're probably best off by simply adding rows where needed, whether for each possible printed page or at the end of all printed pages for a sheet, to provide the summary. Since you said you wanted a formula like SUM(A3:Ax), I presume you only need one row at the end to provide your summary. You might consider attacking the problem from the other end - that is, putting your total at the TOP of first sheet (insert a new row 3?) with a formula that included a range large enough to hold all entries in a column for a long time, like =SUM(A4:A10000) ?? "balu" wrote: dear sir , i want to create the sum of column(cells values ) like sum( "a3:a end ") at the end of the sheet like footer and to have an perfect print out as detail as detail and totals as report footer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Stacked column of multiple values across categories | Charts and Charting in Excel | |||
How to create a report for selected values in the column | Excel Discussion (Misc queries) | |||
Can we Create a column that receives unique values only? | Excel Discussion (Misc queries) | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
How could I create a different first page footer ? | New Users to Excel |