=SUBTOTAL(9, B2:B200)
but the subtotal must be seen either by including a value that the
filter will allow to be displayed, or by being outside the filtered rows.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"alex" wrote in message ...
How I can add a subtotal/total line below a list with auto-filter ?