| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Statistical Functions ignoring errors
Hello,
I am trying to run STDEV(range), where range contains #DIV/0! errors. Is there a way around this? Ive also just worked around it with AVERAGE( range ) by using SUMIF(range, <#DIV/0!)/COUNTIF(range,<#DIV/0!), however I dont think this will be very effective for the standard deviation. -- Thank you, excelBRISKbaby |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Statistical Functions ignoring errors
Ctrl/shift/enter:
=STDEV(IF(ISERROR(range),"",range)) "excelBRISKbaby" wrote in message ... Hello, I am trying to run STDEV(range), where 'range' contains #DIV/0! errors. Is there a way around this? I've also just worked around it with AVERAGE( range ) by using SUMIF(range, "<#DIV/0!")/COUNTIF(range,"<#DIV/0!"), however I don't think this will be very effective for the standard deviation. -- Thank you, excelBRISKbaby |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignoring text and errors with Sumproduct | Excel Worksheet Functions | |||
| A book for statistical functions? | Excel Worksheet Functions | |||
| statistical functions | Excel Worksheet Functions | |||
| Ignoring Lines with Errors in Pivot Tables | Excel Worksheet Functions | |||
| Statistical functions | Excel Worksheet Functions | |||
Linear Mode
