averaging with a filter

  • Thread starter Thread starter AAS
  • Start date Start date
A

AAS

i would like my average of a group of numbers to change when I filter the
numbers in other columns.
thanks alot
 
Hi

Hope this helps:

In cell where you have the Average formula - change it to =subtotal(1,(Range)

This should change as and when you change the filter etc
 
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

Averaging from a cell to the bottom of the list 2
Average value only for the filtered area.. 4
Averaging Data continuously when using Filter function - Need Help 6
Excel Issue with "Average" showing in Status Bar 2
Percentile self adjust with auto filter option turned on 5
Average function 9
AVERAGE ARRAY 1
Averaging Data 2

Back
Top