Auto filter Problem

[Portuga]

From Cell L18 to cell L80 I have cells with numeric values or blan
cells (0). On cell L81 I have the total sum of Cells L18 to L80. So fa
so simple.

U have an auto Filter on some cells on Row 17.My problem is everytime
change one of these filters, the number of rows also changes. Lets sa
it displays cells L19, L20,L26,L56,L77. My problem is that on Cell L81
the sum of those cells is not there.

Can I have an automated way of having the sum of the displayed cells i
column L on Cell L81? Even when I change the filters?

Thank

 

[Andy B]

Hi

Have a look at the SUBTOTAL function.

Andy.