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

"Jim Rech" wrote:

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