| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| standard deviation | Charts and Charting in Excel | |||
| Standard deviation | Excel Discussion (Misc queries) | |||
| Standard deviation of specific cells in a column | Excel Discussion (Misc queries) | |||
| standard deviation | Excel Worksheet Functions | |||
| Standard Deviation | Excel Worksheet Functions | |||
![John D[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
