Averaging

  • Thread starter Thread starter JD
  • Start date Start date
J

JD

I have a spreadsheet with about 300 rows in it showing
monthly volume per employee. I then use the auto filter
to show only the cities or regions I want. I would like
to average the volume of only the items that show up in
the filter. I cannot seem to do this. It averages the
whole list. Please help.
 
JD,

=SUBTOTAL(1;Column with data)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Hi Auk
you probably meant the following :-)
=SUBTOTAL(1,Column with data)

P.S.: what is your Alcohol excuse <vbg>
 
Hi Frank,

No alcohol excuse.
Just a guess that OP had European setting <vbg>
Otherwise : it WAS early this morning

Thanks for pointing to it.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top