Averaging non continuous cells, and ignoring cells with errors

Hi, thanks for taking time to look at this. I need to an average of several cells that are non continuous. The problem is that some cells contain errors. I would like to take the average and ignore the cells containing errors. This worksheet has several pages i need to do this on and is not my creation so i am trying to avoid having to go back and eliminate the errors.

I have tried different versions of IF statements and ISERROR/ISNUMBER in an array format but cannot get the formula (or possibly the syntax) to work for the non continuous range. My data are in cells M10, M20, M30, M43, M53, M63.

Any ideas on how to best accomplish this without a macro?


Thanks

Try

=SUM(IF(ISNUMBER(M10),M10),IF(ISNUMBER(M20),M20), IF(ISNUMBER(M30),M30),IF(ISNUMBER(M43),M43),IF(ISNUMBER(M53),M53),IF(ISNUMBER(M63),M63))/MAX(1,COUNT(M10,M20,M30,M43,M53,M63))

Thanks for the quick response.

NBVC- unfortunately there are other numbers and errors inbetween so that formula does not work.

Daddylonglegs - That formula works perfectly well. Guess i was trying to make it too complicated. Thanks!