subtotal function to get average

[jackie dee]

Hi,

I've used the subtotal function with a filtered list to
get the sum of a column. But how do I get an average
instead.

I'm stuck

Any help would be great

Jackie

 

[Peo Sjoblom]

=SUBTOTAL(1,Range)

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Freemini]

if you are using the formula:
=Subtotal(9,A1:A100) for example
to give the sum all you need to do is change the formula to
=Subtotal(1,A1:A100) to give the average.

hth

Mik

 

[Guest]

Thanks

that worked great

Jackie

 

[Gord Dibben]

For the future............

If you go to Help>Subtotal, you will be shown the 11 numbers corresponding to
the Function you want to use.

Gord Dibben Excel MVP