PC Review


Reply
Thread Tools Rate Thread

Average For Filtered Cells

 
 
carl
Guest
Posts: n/a
 
      12th Apr 2010
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.
 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      12th Apr 2010
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.


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:21 AM.