How to sum one cell across workbook if nr of worksheets is variabl
 

I have a slowly expanding workbook. I wish to have one sheet summarisig the
others. How can I get excel to sum one cell in every worksheet in the book
without having to specify the first and last sheet identities specifically?
e.g. just sum every A1 cell in the book irrespective of number of sheets?
Any help please?

How to sum one cell across workbook if nr of worksheets is variabl
 

Create a sheet "sandwich".

Insert a new sheet to the immediate left the first sheet to be included in
the sum. Name this sheet First. Insert a new sheet to the immediate right of
the last sheet to be included in the sum. Name this sheet Last.

Then your formula would be:

=SUM(First:Last!A1)

Now, when you add new sheets that need to be included in the sum just insert
them between the First sheet and the Last sheet. Any sheet that is between
First and Last will be included in the sum.

--
Biff
Microsoft Excel MVP


"Tezza" wrote in message
...
I have a slowly expanding workbook. I wish to have one sheet summarisig the
others. How can I get excel to sum one cell in every worksheet in the book
without having to specify the first and last sheet identities
specifically?
e.g. just sum every A1 cell in the book irrespective of number of sheets?
Any help please?

How to sum one cell across workbook if nr of worksheets is var
 

Sum the same cell across a number of sheets:
=SUM(sheet1:sheet20!A1)

Don't put that formula in any A1 in any sheet or you'll have a circular
reference.

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"T. Valko" wrote:

Create a sheet "sandwich".

Insert a new sheet to the immediate left the first sheet to be included in
the sum. Name this sheet First. Insert a new sheet to the immediate right of
the last sheet to be included in the sum. Name this sheet Last.

Then your formula would be:

=SUM(First:Last!A1)

Now, when you add new sheets that need to be included in the sum just insert
them between the First sheet and the Last sheet. Any sheet that is between
First and Last will be included in the sum.

--
Biff
Microsoft Excel MVP


"Tezza" wrote in message
...
I have a slowly expanding workbook. I wish to have one sheet summarisig the
others. How can I get excel to sum one cell in every worksheet in the book
without having to specify the first and last sheet identities
specifically?
e.g. just sum every A1 cell in the book irrespective of number of sheets?
Any help please?