View Single Post
  #1   Report Post  
carl
 
Posts: n/a
Default Using The Average Function if a cell has NA

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.