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

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