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
Bookmarks