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?

=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?

Yes...use the 101 code
--
Gary''s Student - gsnu200786


"Bear Black" wrote:

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?

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

Bear Black wrote:

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?

--

Dave Peterson

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

"Gary''s Student" wrote:

Yes...use the 101 code
--
Gary''s Student - gsnu200786


"Bear Black" wrote:

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?