Hi Carl,
Try
=AVERAGE(IF(ISNUMBER(A1:A4),A1:A4))
this is an array formula, so commit with Ctrl-Shift-Enter
--
HTH
RP
(remove nothere from the email address if mailing direct)
"carl" wrote in message
...
I have a formula in Col A,B,C,D that sometimes returns #N/A. I would like
to
average the numbers in Col E but the average function returns #N/A.
Is there a way to use the average function to exclude the NA's ?
Thank you in advance.
|