Hello,

I would like to have an automatic sum as I do filters of categories.

In other words, I would like to be able to have a total of ( XXX)at the
bottom of a column after i DO A FILTER.

Thank you for all your help.

Put at the top using the SUBTOTAL function.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pascale" wrote in message
...
Hello,

I would like to have an automatic sum as I do filters of categories.

In other words, I would like to be able to have a total of ( XXX)at the
bottom of a column after i DO A FILTER.

Thank you for all your help.

This is not working, My file has a filter and in the colums I have names, I
would like to have an automatic total when I do a filter with a name. for
example, when I click on the name Jacques I want to know how many times he is
outlined in that column.

A+

"Don Guillett" wrote:

Put at the top using the SUBTOTAL function.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pascale" wrote in message
...
Hello,

I would like to have an automatic sum as I do filters of categories.

In other words, I would like to be able to have a total of ( XXX)at the
bottom of a column after i DO A FILTER.

Thank you for all your help.