| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum for 26 worksheets on one workbook
=SUM('08-09 ED PYMNTS IN 09-10':'09-10-FSCL ADMN-BGPMNT IN
09-10'!H3) "MO" wrote in message ... Sam, Thank you. Yes, the cell is in the same location on each sheet. I tried it =SUM('08-09 ED PYMNTS IN 09-10'!H3:'09-10-FSCL ADMN-BGPMNT IN 09-10'!H3) and got VALUE as an answer. Did I do something incorrect? -- Thank you for your help MO Albany, NY "Sam Wilson" wrote: =SUM(Sheet2:Sheet26!A1) would work if your cell is in the same location on each sheet. Sam "MO" wrote: Hope someone can help this poor soul! I have 26 worksheets on one workbook that I need to add one cell from EACH worksheet. When I try to add them all, there isn't enough room in the formula box (it covers the formula and I can't choose the cell). Do you know a way to accomplish this? -- Thank you for your help MO Albany, NY |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One workbook with 62 worksheets | Excel Worksheet Functions | |||
| Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
| Can't add worksheets to a workbook. | Excel Discussion (Misc queries) | |||
| Create New Workbook from Worksheets in One Workbook | Excel Discussion (Misc queries) | |||
| How do I build a workbook from the worksheets another workbook? | Excel Discussion (Misc queries) | |||
![Bob Umlas[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
