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

  • Thread starter Thread starter Tino
  • Start date Start date
T

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
 
Back
Top