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




How to skip the blank cells for calculating StdDev?
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. 
Ads 
#2




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 
#3




How to skip the blank cells for calculating StdDev?
"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? 
#4




How to skip the blank cells for calculating StdDev?
> 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  
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
How to count blank cells that contain formula?  IntricateFool  Excel Discussion (Misc queries)  5  June 8th 06 02:45 PM 
Automatically add "0" to blank cells without a formula in the cel.  LuLu  Excel Worksheet Functions  0  May 9th 06 03:13 PM 
Skip blank cells in diagrams  hlp  Charts and Charting in Excel  9  February 24th 06 02:32 PM 
Imported Data creates blank cells that aren't really blank  JackieD  Excel Worksheet Functions  14  February 23rd 06 12:57 AM 
Blank Cells in Pivot Tables  Greg  Excel Discussion (Misc queries)  1  March 16th 05 09:23 PM 