How can I evade the limit of 30 arguments in a function?

M

macca

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.
 
S

Sasa Stankovic

you can use nested functions.fo example:
=sum(arg1,arg2,...,arg29,sum(arg1,ar2,...,arg30))
this way I'm using 59 arguments...
 
H

Harlan Grove

Sasa Stankovic wrote...
you can use nested functions.fo example:
=sum(arg1,arg2,...,arg29,sum(arg1,ar2,...,arg30))
Click to expand...
....

Unnecessary for summing cells. Just use multiple area ranges. For
example, Excel has no trouble with the following.

=SUM((A1,A3,A5,A7,A9,A11,A13,A15,A17,A19,A21,A23,A25,A27,A29,A31,A33,A35,
A37,A39,A41,A43,A45,A47,A49,A51,A53,A55,A57,A59,A61,A63,A65,A67,A69,A71,
A73,A75,A77,A79,A81,A83,A85,A87,A89,A91,A93,A95,A97,A99,A101,A103,A105,
A107,A109,A111,A113,A115,A117,A119,A121,A123,A125,A127,A129,A131,A133,
A135,A137,A139,A141,A143,A145,A147,A149,A151,A153,A155,A157,A159,A161,
A163,A165,A167,A169,A171,A173,A175,A177,A179,A181,A183,A185,A187,A189,
A191,A193,A195,A197,A199,A201,A203,A205,A207,A209,A211,A213,A215,A217,
A219,A221,A223,A225,A227,A229,A231,A233,A235,A237,A239))

That's summing 120 nonadjacent cells.
 
M

macca

Hi Topper
Thank you for reply:
non contiguous eg:

=SUM(B10,E10,H10,N10,Q10,B12,E12,H12,N12,Q12,B14,N14,Q14,B16,E16,H16,N16,Q16,B18,E18,H18,N18,Q18,B20,E20,H20,N20,Q20,B22,E22,H22,N22,Q22,B24,E24,H24,N24,Q24,B26,E26,H26,N26,Q26,B28,E28,H28,N28,Q28,B30,E30,H30,N30,Q30,B32,E32,H32,N32,Q32)
 
Top