View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default 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?