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.

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.

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.

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.