Total filtered data on top

[Pypcik27]

Could someone help me with inserting a row on top with a totaling function on filtered data, I want it to go right below the actual filter.

Thank you

 

[GlennUK]

I say insert a row above the actual filter.

 

[Pypcik27]

I know how to insert row, I need a function to insert a subtotal on filter

 

[GlennUK]

If you insert a row above the filter, and use the SUBTOTAL(9 function there, you'll see a total of the filtered data. And it will be visible all the time.

 

[Pypcik27]

Thank you so much!