Exceeding the maximum of 30 arguments of functions like STDEV

J

Jurry

I have more than 30 cells (not connected with each other) which I wan
to use as arguments for excell functions like STDEV. However, accordin
to the help file STDEV can only handle a maximum of 30 arguments. Ar
there ways around this problem (apart from writing your own STDE
function)?

Thanks,
Jurry
 
K

kkknie

If you are talking about a worksheet formula, you can get around thi
limitation by defining named ranges. I was able to select 19 separat
(non-contiguous) cells and define them as a named range (not sure o
the max here since I do not use named ranges too often). So in theory
you could do that 30 times and get a STDEV for 19x30 = 570 points. I
some of them are next to each other, the number gets even higher.

If you mean in code, I believe you do not have that limitation with th
range object. I was able to select 50 different cells using the forma
Range("A1,A3,A5,A7,....A100").Select.
 
J

Jurry

Thanks, it worked!
Jurry.
*If you are talking about a worksheet formula, you can get aroun
this limitation by defining named ranges. I was able to select 1
separate (non-contiguous) cells and define them as a named range (no
sure of the max here since I do not use named ranges too often). S
in theory, you could do that 30 times and get a STDEV for 19x30 = 57
points. If some of them are next to each other, the number gets eve
higher.

If you mean in code, I believe you do not have that limitation wit
the range object. I was able to select 50 different cells using th
format Range("A1,A3,A5,A7,....A100").Select.

K
Click to expand...
 
J

JE McGimpsey

Select your cells and give them a name (say, rng) by typing the name in
the name box (to the left of the formula bar). then use

=STDEV(rng)
 
Top