Averaging only visible cells

[Bear Black]

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?

 

[Gaurav]

=SUBTOTAL(101,A2:A10)

Change the range to suit.

 

[Gary''s Student]

Yes...use the 101 code

 

[Dave Peterson]

If you're not using xl2003+, then the old version of =subtotal() won't support
the 1## parm.

 

[Bear Black]

Thanks very much for your help!! Worked like a champ.