It sounds like there is a macro coming in to play which re-places that
formula each time a new "filter" is effected. One way to do this without
macros, which I use a lot is to FREEZE the top 8 or 10 rows on the sheet and
put my SUBTOTAL formulas above that freezeline, that way they are always
visible no matter where I am looking at the filtered data.

hth
Vaya con Dios,
Chuck, CABGx3



"confused" wrote:

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!