=SUBTOTAL(101,A2:A10)

Change the range to suit.


"Bear Black" wrote in message
...
I know there is a subtotal function that will only add up visible cells
when
using filters, but is there a formula that will average only visible cells
when using filters?