View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How to skip the blank cells for calculating StdDev?

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