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.