Ali,

Let's say that you want to filter columns A to H, and your SUBTOTAL formulas are in column G. You
can

1) change the SUBTOTAL formulas to values prior to filtering, but then you lose the usefulness of
the SUBTOTAL function, which works on visible cells only.
2) move column G to beyond your current H, or before your current A, and then when you apply the
filters, do not select that column.

HTH,
Bernie
MS Excel MVP


wrote in message
oups.com...
Yes Bernie, In ONE of the two columns that im using Autofilter ( the
one with "<0") the data is the subtotal of four other columns.

I didnt get the solution you proposed ? Would u mind explaining a
little ? and Wud it help if I Copy and Paste that columns, pasting the
VALUES, so that the subtotal function is done away with altogether ??

Thanks for ure help in advance...