PC Review


Reply
Thread Tools Rate Thread

count and filter

 
 
f_esfandiari@yahoo.com
Guest
Posts: n/a
 
      23rd Aug 2007
Dear Reader

Do you know whether there is a function that counts only the filtered
elements of a column and not the whole column?

Regards
Farhad

 
Reply With Quote
 
 
 
 
=?Utf-8?B?T3NzaWVNYWM=?=
Guest
Posts: n/a
 
      23rd Aug 2007

=SUBTOTAL(2,A2:A100)

Edit A2:A100 to include the entire list of data as if unfiltered. It then
returns a count of the filtered data.

Lookup subtotal in Help and you will find a number of different functions
that can be performed depending on the numerical parameter (2 in the above
example).

Regards,

OssieMac
"(E-Mail Removed)" wrote:

> Dear Reader
>
> Do you know whether there is a function that counts only the filtered
> elements of a column and not the whole column?
>
> Regards
> Farhad
>
>

 
Reply With Quote
 
Dolphinix
Guest
Posts: n/a
 
      23rd Aug 2007
try using the "Subtotal" function with the option number 2.

HTH


On Aug 23, 5:38 am, f_esfandi...@yahoo.com wrote:
> Dear Reader
>
> Do you know whether there is a function that counts only the filtered
> elements of a column and not the whole column?
>
> Regards
> Farhad



 
Reply With Quote
 
Matt
Guest
Posts: n/a
 
      23rd Aug 2007
On Aug 23, 5:38 am, f_esfandi...@yahoo.com wrote:
> Dear Reader
>
> Do you know whether there is a function that counts only the filtered
> elements of a column and not the whole column?
>
> Regards
> Farhad


Select the items in the column and then use the functions in the
bottom right corner of the window to COUNT the visible cells

 
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
filter count =?Utf-8?B?VGVhY2hlckQ=?= Microsoft Excel Misc 3 31st May 2007 04:17 PM
Count & Filter =?Utf-8?B?TmV0d29ya1RyYWRl?= Microsoft Access Queries 5 30th Oct 2006 09:31 PM
count value with filter... =?Utf-8?B?c2FsMjE=?= Microsoft Excel Programming 0 20th Sep 2006 04:00 PM
Count Filter =?Utf-8?B?TWFuZGVlcCBEaGFtaQ==?= Microsoft Excel Misc 5 20th Jan 2006 01:19 PM
filter and count =?Utf-8?B?cmV4bWFubg==?= Microsoft Excel Misc 2 30th Nov 2004 02:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:09 AM.