Hi! I have a list where some cells have missing values (ie it says #MISSING
VALUE) in the cell (the list is linked to other lists). I want to be able to
calculate the average, mx, min etc for this list but it does not work since I
have the missing values. i want to convert them to 0. how can i do this? pls
help!

Try something like

=AVERAGE(IF(NOT(ISERROR(A1:A20)),A1:A20))

which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arne Hegefors" wrote in message
...
Hi! I have a list where some cells have missing values (ie it says
#MISSING
VALUE) in the cell (the list is linked to other lists). I want to be able
to
calculate the average, mx, min etc for this list but it does not work
since I
have the missing values. i want to convert them to 0. how can i do this?
pls
help!