If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Summing large quanity of random Cells With Auto Formula
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. |
#2
|
|||
|
|||
Summing large quanity of random Cells With Auto Formula
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) -- Regards, Peo Sjoblom wrote in message ... 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. |
#3
|
|||
|
|||
Summing large quanity of random Cells With Auto Formula
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,A 27,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 -----Original Message----- 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. . |
Thread Tools | |
Display Modes | |
|
|