sum of columns at bottom of each sheet

[steve88]

Version: 2008

is it possible to sum columns at the bottom of each sheet without having to format each sheet that way? I just want to keep adding numbers in each column and have the total at the bottom of each sheet

 

[Bob Greenblatt]

Version: 2008

is it possible to sum columns at the bottom of each sheet without having to
format each sheet that way? I just want to keep adding numbers in each column
and have the total at the bottom of each sheet

I'm really not sure what you mean. You can place a sum formula anywhere and
have it include many blank rows above it. Then when new numbers are added
they will appear in the total. If you want some thing else, please be more
specific.

 

[steve88]

My columns will be very long eventually so I don't want to have to format a sum on each page. I didn't know if there was a way to use the footer possibly to sum all input on each page automatically.

 

[Bob Greenblatt]

My columns will be very long eventually so I don't want to have to format a
sum on each page. I didn't know if there was a way to use the footer possibly
to sum all input on each page automatically.

I still do not know what you mean by "format a sum". Without a lot of macro
code, you cn not put page sums in the page's footer. If you want totals at
the bottom of each page, you will have to structure the page, and place sum
formulas in the appropriate rows.