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 |
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 |
All times are GMT +1. The time now is 08:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com