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

"AAS" wrote:

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