auto SUM a FILTERED List

[davidbrowne17]

When using the AUTO filter, is there a forumular to SUM the filtered
list ( i.e Displayed items)

I have used the SUM fuction, this will add up the current filtered
list, but then not change when the filter citeria is changed

Regards

David.

 

[Stephen Bye]

Use SUBTOTAL(9,range) instead of SUM(range) to total just the selected rows