Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I evade the limit of 30 arguments in a function?
I would like to add more than 30 cells and place that value in another cell.
I am being stymied at present by the limit of 30 arguments to a function. At present, i must split the calculation, and then pick these split values and tie them into my result cell. I know that this will work, but it seems messy to my way of thinking. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I evade the limit of 30 arguments in a function?
I assume the cells are not contiguous ... can you post example of your formula?
"macca" wrote: I would like to add more than 30 cells and place that value in another cell. I am being stymied at present by the limit of 30 arguments to a function. At present, i must split the calculation, and then pick these split values and tie them into my result cell. I know that this will work, but it seems messy to my way of thinking. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I evade the limit of 30 arguments in a function?
you can use nested functions.fo example:
=sum(arg1,arg2,...,arg29,sum(arg1,ar2,...,arg30)) this way I'm using 59 arguments... "macca" wrote in message ... I would like to add more than 30 cells and place that value in another cell. I am being stymied at present by the limit of 30 arguments to a function. At present, i must split the calculation, and then pick these split values and tie them into my result cell. I know that this will work, but it seems messy to my way of thinking. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I evade the limit of 30 arguments in a function?
Hi Topper
Thank you for reply: non contiguous eg: =SUM(B10,E10,H10,N10,Q10,B12,E12,H12,N12,Q12,B14,N 14,Q14,B16,E16,H16,N16,Q16,B18,E18,H18,N18,Q18,B20 ,E20,H20,N20,Q20,B22,E22,H22,N22,Q22,B24,E24,H24,N 24,Q24,B26,E26,H26,N26,Q26,B28,E28,H28,N28,Q28,B30 ,E30,H30,N30,Q30,B32,E32,H32,N32,Q32) "Toppers" wrote: I assume the cells are not contiguous ... can you post example of your formula? "macca" wrote: I would like to add more than 30 cells and place that value in another cell. I am being stymied at present by the limit of 30 arguments to a function. At present, i must split the calculation, and then pick these split values and tie them into my result cell. I know that this will work, but it seems messy to my way of thinking. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range limit for auto filter function | Excel Discussion (Misc queries) | |||
creating function (vba) with range arguments | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Event hundler to control the Excel function arguments | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |