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?
|