Hi, please help.
I have this group of filtered data which I need to get the average excluding NA and negative numbers.
My initial formula is =AVERAGE(IF(SUBTOTAL(9,OFFSET(FG$11:FG$500,ROW(FG$11:FG$500)-MIN(ROW(FG$11:FG$500)),,1)),--(FG$11:FG$500<>"NA"),--(FG$11:FG$500>0))) but unfortunately, not working.
Sample data:
24
12
-42895
NA
NA
Thank you!!
Bookmarks