how do i link 3 worhseets to calculate into one

[never]

using excel 2003, i need to link 3 worksheets into a 4th one that will
calculate the totals of all three. the first three should operate independent
of each other, i.e. they should not calculate each other only within itself.
this is for a quartrly report, 3 months to calculate together to show the
total of the three.

[Roger Govier]

Hi

Assuming your data is on Sheet1, Sheet2 and Sheet3. On Sheet4
=SUM(Sheet1:Sheet3!A1) will total all of the values from cell A1 of the
other three sheets.
Adjust to pick up the cell values you wish to summarise.

--
Regards

Roger Govier


"never" <[email protected]> wrote in message
news:[email protected]...
> using excel 2003, i need to link 3 worksheets into a 4th one that will
> calculate the totals of all three. the first three should operate
> independent
> of each other, i.e. they should not calculate each other only within
> itself.
> this is for a quartrly report, 3 months to calculate together to show
> the
> total of the three.