Thread: Standard Deviation including blank cells
View Single Post
  #7   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
However, under the rule that "simpler is better", I must say T. Valko's
solution of simply adding a "0" to each value in the array appears to be the
simplest solution.

=STDEV(D8:AD8+0)

John D

Reply With QuoteReply With Quote