Hi

Do you mean =SUM(Sheet1:Sheet5!A1:A20)

Regards

Roger Govier


amartin-kelly wrote:
How would I set up a formula that consists of a sum on page 1 + a sum on
page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?