Need an (average) formula

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I need this formula =average(F2:F300) to change when I filter names in column A. Please help.

Excel 2007

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
perhaps you need a macro

copy filtered data in another location and find the av erage

RECORD the macro following the steps.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
what version of office you are talking about here. I have not checked in other version but you can use SUBTOTAL function to get the average or other summary info for only visible rows/range in office 2007

for avg that would be

=subtotal(101, F2:F300)