count / average formulas to be affected by filters

[OneLooseCrank]

Hi all,
I'm looking to filter data and have the displayed results averaged in a column header. Between the data and column header I have the filters. I'd like the totals at the column header to take into account only the data being shown below. There must be a really logical way of doing this - or do I need to use pivot tables? I haven't really used this function before...

 

[FormR]

Hi, the SUBTOTAL() function ignores filtered rows.

https://support.office.com/en-gb/article/SUBTOTAL-function-7b027003-f060-4ade-9040-e478765b9939