| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula is too long, (error message)
I am trying to sum numerous worksheets into a different workbook summary
sheet, however each time I select a cell within in the workbook it included the workbook name and then the name of the worksheet and then the cell. Is there a way that the workbook can be noted at the beginning of the formula and then the rest of the formula will be the addition of each worksheet? eg. =sum('[Tracking revision2.xls]Sprinkler Fitters'!$C$6, '[Tracking revision2.xls]Scaffolder!$C$6) and so on forth. I would like to make it so the workbook is only mentioned once at the beginning to shorten the formula. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula too long error? | Excel Worksheet Functions | |||
| Error message "formula is too long" | Excel Discussion (Misc queries) | |||
| Error message "formula is too long" | Excel Worksheet Functions | |||
| "string too long" error message | Excel Discussion (Misc queries) | |||
| "formula too long" error message | Excel Discussion (Misc queries) | |||
Threaded Mode
