Does anyone know how to skip the blank cells for calculating StdDev?
such as, there are a set of data in each cell under colume A, the number of
row will keep changing, but the maximum row of data is 600, so I input the
formula in as following
A601 cell =StdDev(A1:A600,count(A1:A600),0), if the number of data is 600,
then it will be corrected, but if the number of data is 60 only, then the
result is 0.
However, if I change the code as following StdDev(A1:A60,count(A1:A60),0),
then I receive 81 as the result. Does StdDev count the blank cell as a 0
value for following coding StdDev(A1:A600,count(A1:A600),0)? so the result is
0.

Since empty cells are ignored by STDEV (re Excel Help),
how about just using: =STDEV(A:A)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
Does anyone know how to skip the blank cells for calculating StdDev?
such as, there are a set of data in each cell under colume A, the number of
row will keep changing, but the maximum row of data is 600, so I input the
formula in as following
A601 cell =StdDev(A1:A600,count(A1:A600),0), if the number of data is 600,
then it will be corrected, but if the number of data is 60 only, then the
result is 0.
However, if I change the code as following StdDev(A1:A60,count(A1:A60),0),
then I receive 81 as the result. Does StdDev count the blank cell as a 0
value for following coding StdDev(A1:A600,count(A1:A600),0)? so the result is
0.
Does anyone know how to solve this issue? the number of data is not fixed
and I need to calculate StdDev for this variable size of data.
Thank you in advance
Eric

"Eric" wrote apparently:
Does anyone know how to skip the blank cells for calculating StdDev?
[....]
I input the formula in as following
A601 cell =StdDev(A1:A600,count(A1:A600),0)

Since there is no Excel function called StdDev [sic] and since those
are not the correct parameters for the Excel STDEV() function, I
wonder: what exactly are you talking about? Is StdDev() perhaps a UDF
written in VBA?

wrote
Since there is no Excel function called StdDev [sic] ...

Sorry, my eyes mistook it earlier for STDEV
Pl disregard my response ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---