=STDEV(IF(D8:AD8=0,D8:AD8))

ctrl+shift+enter, not just enter


"John D" wrote:

I have a range of cells for which I want to calculate standard deviation -
*including* blank cells. Example, if (D8:AD:8) has numbers in 20 columns and
blanks in 6 columns, I want the formula to interpret those 6 blanks as "0".

The data is being imported from a large database and the data set being
imported will vary. I suppose I could somehow force all blank cells to be "0"
when imported, but I'd prefer not.

Any other way? Thanks - John D