View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John D[_2_] John D[_2_] is offline
external usenet poster
 
Posts: 12
Default Standard Deviation including blank cells

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