View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Standard Deviation including blank cells

That's the one I'd use! <g

Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"John D" wrote in message
...
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