Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on Adding the same cell in different sheets.
I am working on a big excel sheet, and I am kinda new at it. How can I get a
sum of the values on 45 different excel sheets? I can only get the sum of about 15 sheets for so before it says that my formulat is too long. Here is an example of the formula: =SUM('Service Invoice (45)'!D29+'Service Invoice (44)'!D29) I need to get the sum of cell D29 from sheets 1-45. thanks for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on Adding the same cell in different sheets.
Hi!
Try this: =SUM('Service Invoice (1):Service Invoice (45)'!D29) Any sheets (tabs) that are physically located in between Service Invoice (1) and Service Invoice (45) will be included in the calculation. Biff "Anakin7279" wrote in message ... I am working on a big excel sheet, and I am kinda new at it. How can I get a sum of the values on 45 different excel sheets? I can only get the sum of about 15 sheets for so before it says that my formulat is too long. Here is an example of the formula: =SUM('Service Invoice (45)'!D29+'Service Invoice (44)'!D29) I need to get the sum of cell D29 from sheets 1-45. thanks for your help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on Adding the same cell in different sheets.
See response to your other posting in excel.misc
Please do not multi-post. Cross-post if you must, but do not multi-post. Just serves to fragment responses and can lead to a waste of time and effort for responders. Gord Dibben MS Excel MVP On Tue, 26 Sep 2006 19:02:01 -0700, Anakin7279 wrote: I am working on a big excel sheet, and I am kinda new at it. How can I get a sum of the values on 45 different excel sheets? I can only get the sum of about 15 sheets for so before it says that my formulat is too long. Here is an example of the formula: =SUM('Service Invoice (45)'!D29+'Service Invoice (44)'!D29) I need to get the sum of cell D29 from sheets 1-45. thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming sheets from a cell value | Excel Discussion (Misc queries) | |||
Changed referenced cell between sheets | Excel Discussion (Misc queries) | |||
How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) |