how do i link 3 worhseets to calculate into one

N

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.
 
R

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.
 
Top