How do I add cells from different worksheets?

[Guest]

I am trying to add totals from 5 separte worksheets on the last worksheet
which I am calling a summary page. Can anyone share with me how to do this? I
tried the Sum button and then holding control as I click on each total on the
different worksheets but it doesn't seem to be working.

 

[Jim Rech]

Assuming the amounts are on the same cell on each worksheet use a formula
like this:

=SUM(Sheet1:Sheet5!A1)

Otherwise you'd need a formulas like this:

=Sheet1!A1+Sheet2!B2+Sheet3!C3+..

--
Jim Rech
Excel MVP
|I am trying to add totals from 5 separte worksheets on the last worksheet
| which I am calling a summary page. Can anyone share with me how to do
this? I
| tried the Sum button and then holding control as I click on each total on
the
| different worksheets but it doesn't seem to be working.

 

[AnnaV]

If you want to enter the totals seperately you could just click in eac
cell that you want to enter each total in sheet 5 and enter =then clic
on the sheet with the total in it and click on the cell that you wan
and press enter. The formula will read ='Sheet 1'!A1 or where ever th
cell is and continue with each cell. If you want to add them instead o
pressing enter press + and at the end press enter

 

[Guest]

Thank You Jim! I will try that!

 

[Guest]

I cannot get either of these methods to work for me. Am I doing something
wrong?