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.

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" wrote in message
...
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.