A
alex
How I can add a subtotal/total line below a list with auto-filter ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
KL
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
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
A
alex
thanks for reply.
the problem is that when i choose some criteria in one of the columns to
filter the list, the subtotal dissapears
the problem is that when i choose some criteria in one of the columns to
filter the list, the subtotal dissapears
K
KL
that's becuase you need to ensure that there is at least one totally empty
row between your subtotals and the last row of the table being filtered.
regards,
KL
row between your subtotals and the last row of the table being filtered.
regards,
KL
A
alex
thanks, it works now..
KL said:that's becuase you need to ensure that there is at least one totally empty
row between your subtotals and the last row of the table being filtered.
regards,
KL