Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding up multiple cells
I have 21 workbooks. I need to add up 3 cells out of each workbook and place
it in a seperate workbook. In other words how do I add up 60 cells or so? I have tried by just opening the workbooks and then highlighting the cells and then adding them up but I can only get 25 cells or so. Any idea's or comments will be greatly appreciated. Thanks once again! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding up multiple cells
I seem to think that the maximum length of a text string is something like
250 characters which is probably what is causing the problem. Can you add up the 3 cells in each book and then just include the totals in your new book? HTH - Sheila www.c-i-m-s.com MS Office training - London "Andy" wrote: I have 21 workbooks. I need to add up 3 cells out of each workbook and place it in a seperate workbook. In other words how do I add up 60 cells or so? I have tried by just opening the workbooks and then highlighting the cells and then adding them up but I can only get 25 cells or so. Any idea's or comments will be greatly appreciated. Thanks once again! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding up multiple cells
Excel formulas are limited to 30 arguments.
You will have to find some other way. Sheila's suggesyion has merit. Gord Dibben MS Excel MVP On Tue, 11 Jul 2006 08:19:01 -0700, Sheila D wrote: I seem to think that the maximum length of a text string is something like 250 characters which is probably what is causing the problem. Can you add up the 3 cells in each book and then just include the totals in your new book? HTH - Sheila www.c-i-m-s.com MS Office training - London "Andy" wrote: I have 21 workbooks. I need to add up 3 cells out of each workbook and place it in a seperate workbook. In other words how do I add up 60 cells or so? I have tried by just opening the workbooks and then highlighting the cells and then adding them up but I can only get 25 cells or so. Any idea's or comments will be greatly appreciated. Thanks once again! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up data in multiple cells for a single criteria. | Excel Worksheet Functions | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
Adding separate accumulators for multiple cells | New Users to Excel |