If I have multiple spreadsheets with a subtotal on the same cell on each
sheet, say cell "A1". How do I add all these numbers up without clicking on
each cell to add to the Sum function?

If those sheets are contiguous, say sheets 1 through 6, use

=SUM(Sheet1:Sheet6!A2)


"Derrard" wrote:

If I have multiple spreadsheets with a subtotal on the same cell on each
sheet, say cell "A1". How do I add all these numbers up without clicking on
each cell to add to the Sum function?

Hi!

Make sure all the sheets needed are contiguous:

Tab order:

Summary | Sheet1 | Sheet2 | Sheet3 |


Then:

=SUM(Sheet1:Sheet3!A1)

Or, this is a popular method:

Enter an empty sheet named Start before Sheet1 and another empty sheet named
End after Sheet3:

Summary | Start | Sheet1 | Sheet2 | Sheet3 | End |

Then:

=SUM(Start:End!A1)

Any sheets between Start and End will be included in the Sum.

Biff

"Derrard" wrote in message
...
If I have multiple spreadsheets with a subtotal on the same cell on each
sheet, say cell "A1". How do I add all these numbers up without clicking
on
each cell to add to the Sum function?

Derrard, something like this,

=SUM(Sheet1:Sheet3!A1)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Derrard" wrote in message
...
If I have multiple spreadsheets with a subtotal on the same cell on each
sheet, say cell "A1". How do I add all these numbers up without clicking
on
each cell to add to the Sum function?