And remember that =subtotal() will ignore those values hidden by the autofilter.

You may want to dump the autofilter and (if your data is sorted nicely) use
Data|Subtotals.

alex wrote:

How I can add a subtotal/total line below a list with auto-filter ?

--

Dave Peterson