auto SUM a FILTERED List

  • Thread starter Thread starter davidbrowne17
  • Start date Start date
D

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.
 
Use SUBTOTAL(9,range) instead of SUM(range) to total just the selected rows
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto-filter with Sum product? 2
VBA: How can I use a string variable as autofilter criteria? 4
Sum after Filter, Count after Fliter 2
sum of visable cells in filtered range 7
I want to add up the result of a filtered list 1
count unique values with auto-filter on 6
How can I copy the sum of a filtered column into a cell in anothe 1
How to make "countif" on a filtered excel-list? i.e. like subtotal 4

Back
Top