Use an array function akin to

=STDEV(IF(NOT(ISERROR(A1:E3)),A1:E3))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"tom ossieur" wrote in message
...
Hi,

I am doing some calculations in several steps. In some steps the result of
some cells is #DIV/0!

as a result the final result (STDEV) gives #REF!

how to exclude the cells that contain #DIV/0! so I get the result in the
last step, based on the cells that had a intermediate result? (without
adapting ALL intermdiate steps with IF etc)

so i am looking for a simple trick in the last step

Thanks!

tom