One mo

=SUMIF(A1:A5,"<"&1E100)/COUNT(A1:A5)


--
Biff
Microsoft Excel MVP


"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?