Auto Filter + subtotal
 

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

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 ?

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 ?

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

"alex" wrote in message
...
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 ?

thanks, it works now..

"KL" wrote:

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

"alex" wrote in message
...
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 ?