ExcelBanter - Standard Deviation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Standard Deviation (https://www.excelbanter.com/excel-worksheet-functions/76716-standard-deviation.html)

Stan Banner

Standard Deviation

Hi:
Can someone tell me if there is a way to get the standard deviation from a
range of data that includes blanks, where I want the blanks to be ignored.
Thanks
Stan

Biff

Standard Deviation

Hi!

STDEV() ignores blank cells, text entries, and logical values.

Biff

"Stan Banner" wrote in message
news:yAFQf.135320$B94.5169@pd7tw3no...
Hi:
Can someone tell me if there is a way to get the standard deviation from a
range of data that includes blanks, where I want the blanks to be ignored.
Thanks
Stan

All times are GMT +1. The time now is 01:09 PM.