Home 
Search 
Today's Posts 
#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. 
#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  
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How to count blank cells that contain formula?  Excel Discussion (Misc queries)  
Automatically add "0" to blank cells without a formula in the cel.  Excel Worksheet Functions  
Skip blank cells in diagrams  Charts and Charting in Excel  
Imported Data creates blank cells that aren't really blank  Excel Worksheet Functions  
Blank Cells in Pivot Tables  Excel Discussion (Misc queries) 