averaging with a filter

A

AAS

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

Peter

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
 
Top