I have a sheet with over 20 000 rows and 20+ columns. I have several values in column "P" that I want to filter to find Average value from column "I". I have the headers in row 2 and the function in row 1. When I use =average(I3:I20000) in cell "I1" I'm not getting the filtered visible values. I need to get the average of the filtered values in column "I". Is there a way to do this?
Thanks
Bookmarks