How to skip the blank cells for calculating StdDev?
 

Quote from Excel Worksheet Function.
Please help !!!

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 the result 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.

How to skip the blank cells for calculating StdDev?
 

Eric,

Pl do not multi-post. It's much easier to keep the ball rolling if you stay
within your original thread in .worksheet.functions, where you had 2
responses already, from me and joeu2004. I probably mis-read it there in my
response (thanks to joeu2004's response <g), but you should reply further
to joeu2004's response over there to get things going.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---