Formula

[Pat]

How would I set up a formula that consists of sum of a column on page 1, sum
of column on page 2, sum of a column on page 3, a sum of column on page 4
and posting the results out on page 5?

 

[Don Guillett]

=SUM(Sheet1:Sheet2!A1:A21)

 

[Paul C]

This formula would go on page (or Sheet5).
=SUM(Sheet1!A:A,Sheet2!B:B,etc..)

 

[Pat]

Thank you so much, this put me on the right path, and I was able to complete
my worksheet.