Summing large quanity of random Cells With Auto Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When Summing More Than Thirty Random Cell Values is there
any way to override the Limitation? I Normally Activate
the target cell then click Fx, Hold Down Ctrl. and click
on Random Sub-Totals to obtain the sum. If more than
thirty sub totals in formula Excell will not compute.
 
Just use extra parenthesis

=SUM((1 to 30 cells),next 30)

add another left and go for another 30

=SUM(((1 to 30 cells),next 30),next 30)
 
Either enclose the set of 30 arguments within another set
of ():

=SUM
((A1,A3,A5,A7,A9,A11,A13,A15,A17,A19,A21,A23,A25,A27,A29,A3
1,A33,A35,A37,A39,A41,A43,A45,A47,A49,A51,A53,A55,A57,A59),
A61,A63,A65)

or use defined names:

=SUM(myrng)

where "myrng" = the range above.

HTH
Jason
Atlanta, GA
 
Back
Top