Average For Filtered Cells

's Computer Specifications

I use the auto-filter feature.

Is there a formula I can use that will compute the average of the values in
a column for just the cells that are displayed after using the auto filter ?

Thank you in advance.

's Computer Specifications

Look in the help index for SUBTOTAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"carl" <(E-Mail Removed)> wrote in message
news:FC1FDF1F-5BD1-4145-A024-(E-Mail Removed)...
>I use the auto-filter feature.
>
> Is there a formula I can use that will compute the average of the values
> in
> a column for just the cells that are displayed after using the auto filter
> ?
>
> Thank you in advance.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average value only for the filtered area..	Sasikiran	Microsoft Excel Misc	4	3rd Jun 2010 05:50 PM
Re: Average Last 100 Filtered Visible rows	T. Valko	Microsoft Excel Worksheet Functions	1	18th Sep 2009 02:12 AM
average filtered values	Gaurav	Microsoft Excel Worksheet Functions	4	31st Mar 2008 11:23 PM
Average of filtered data	=?Utf-8?B?QmVuamFtaW4=?=	Microsoft Excel Worksheet Functions	3	3rd Jun 2005 02:20 PM
average of visible cells in a filtered range	=?Utf-8?B?ZGF2ZSByb3Ro?=	Microsoft Excel Worksheet Functions	5	23rd May 2005 12:56 PM