Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link cell in to different worksheets in same workbook excel 2003 | Excel Discussion (Misc queries) | |||
Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
Need HELP! Solve for mortgage interest rate with following variabl | Excel Worksheet Functions | |||
Sum same cell/range of multiple worksheets within a workbook... | Excel Worksheet Functions | |||
Sum of cell on numerous worksheets in a workbook | Excel Worksheet Functions |