Hi,

I have a spreadsheet created by someone else. Autofilter is on all columns,
and there is a row at the bottom called TOTAL which has SUBTOTAL values in
it. When I filter, the TOTAL row is always displayed, which is what I want,
but I cant really understand why it is always displayed.
I actually want to add a second row which will always be displayed, but
beacuse I dont understand how it works, i'm not sure how to do this.

any ideas would be helpful

thanks!