Hi!

Entered as an array with the key combo of CTRL,SHIFT,ENTER:

=AVERAGE(IF(ISNUMBER(A1:A10),A1:A10))

=MIN(IF(ISNUMBER(A1:A10),A1:A10))

=MAX(IF(ISNUMBER(A1:A10),A1:A10))

Biff

-----Original Message-----
I have read through most of posts that seem to apply but
haven't found a
formula that will allow me to calculate the AVERAGE, MAX
and MIN for a data
range that also contains #N/A in several cells. Can you
help?
--
RonB
.