subtotal function to get average

  • Thread starter Thread starter jackie dee
  • Start date Start date
J

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
 
=SUBTOTAL(1,Range)

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
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
 
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
 
Back
Top