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

  • Thread starter Thread starter Tezza
  • Start date Start date
T

Tezza

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?
 
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.
 
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---
 
Back
Top