Cells A2:A21 on sheet 1 contain a list of numbers. Cell A1 on sheet 2 represents the average of these numbers. If I was to filter column A on sheet 1 to look for '4' for example I'd like the average in cell A1 of sheet 2 to display the filtered average (so '4').

With the filtering of column A on sheet 1, column B is also filtered and I'd like the average in cell B1 to also represent the filtered data.

Thanks in advance for any suggestions.Sample 3.xlsx