thanks for reply.
the problem is that when i choose some criteria in one of the columns to
filter the list, the subtotal dissapears

"KL" wrote:

Hi,

Just go to the end of the list, skip one empty line and in the next line use
the function SUBTOTAL(). The 1st argument will be the operation you want to
perform (e.g. 1 for Average, 9 for Sum, etc. see Excel's Help for the
function) and the 2nd is the range you want to total including hidden and
visible rows.

Regards,
KL


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