Suming the same column over multiple pages

Samuel Dowdy Jr.

Is there an easy way to sum a column that is share over multiple pages?

Paul Newcome

You could also sum each column on each sheet individually, use cell linking to pull it over to the summary sheet, then sum the cell linked column. That makes it a little easier to add sheets if you are working with a template layout type of setup.

Paul Newcome

You will have to create separate SUM formulas and add them together.

=SUM({Sheet 1 Column}) + SUM(Sheet 2 Column} + .....................................

Samuel Dowdy Jr.

I was hoping to avoid that... Thank you for the help :-)

Paul Newcome

You could also sum each column on each sheet individually, use cell linking to pull it over to the summary sheet, then sum the cell linked column. That makes it a little easier to add sheets if you are working with a template layout type of setup.