Statistical Functions ignoring errors

[Guest]

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.

 

[Bob Umlas]

Ctrl/shift/enter:
=STDEV(IF(ISERROR(range),"",range))