AVERAGE excluding #N/A

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