Average

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

In order to get my line chart to break off I used #N/A.
However my final value is an average. Since I am using the
#N/A, I get that for my result in my Average calculation.
Is there a work around for this?

Value
2
4
6
#N/A
#N/A

#N/A Average - I want to see 4

THank you,
Jason
 
Hi Jason,
Try this =AVERAGE(IF(ISNUMBER(A1:A5),A1:A5,""))
You must enter it as an array formula with Shift+CTRL+Enter
Bernard
 
Back
Top