How to add the same cell on multiple spreadsheet?
 

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?

How to add the same cell on multiple spreadsheet?
 

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?

How to add the same cell on multiple spreadsheet?
 

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?

How to add the same cell on multiple spreadsheet?
 

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?