=AVERAGE(IF(ISNA(A1:A5),"",A1:A5)) entered as an *array formula* (Control
Shift Enter).
--
David Biddulph

"tylermdsm" wrote in message
...
i'm trying to average 5 cells. One has an #n/a value. This causes the
average to say #n/a. Is there a way to correct this?