Average ifs for filtered data

Hi Everyone,

This is my first post here!

I am trying to play around with data on a trading strategy I have been working on.

I have imputed my data into a spreadsheet I got from someone online.

However, as I try to filter data, the 'Avg Win' in cell I6 does not change. The cell always produces 80 even if rows have been filtered out.

Usually, I would use subtotals for filtered data, but it does not have an averageifs option here.

I have looked online at cases where others have had a similar problem to me; however, cannot seem to replicate their formula solutions in the context of my data.

Any help will be appreciated.

I have attached a visual aid and an excel file!


Thanks
Mikes_KM