How do you sum only visible cells when you have a filtered list?

[Tino]

Hi,

I have a list and have a data filter on that list.

I also have a sum formula at the bottom of the list and I only want
the sum formula to add up displayed values.

I'm sure I did this a long time ago but cannot, for the life of me
remember how.

Any help would be very much appreciated.

Thanks

 

[Harald Staff]

Hi

SUBTOTAL will do this.