Sum of 4 sheets

[Yogi]

I have four sheets eats with a total on it, I would like
to have a cell on sheet 1 that adds all 4 totals on all 4
sheets together. Can anyone help me.
Thank You

 

[Peo Sjoblom]

=SUM(Sheet1:Sheet4!H1)

 

[Norman Harker]

Hi Yogi!

Try:
=SUM('Sheet2:Sheet5'!A1)

But with named sheets you are best off using a point and click
approach

In the cell for the total put
=SUM(
Now point and left click the cell in the first sheet
Press Shift
Now point to the last sheet
)
Press Enter

This will give you something like:
=SUM('Q 1:Q 4'!A1)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.