Filters

srmorgan · Apr 30th, 2002, 09:59 AM

I am using auto filter to clean up a file.
Sometimes when I filter out a variable I get a little message in the lower left hand corner of the screen stating the number of records.
Sometimes I don't.
Any idea why?

Also, how can I get the count of the records pulled up by the filter?

Thanks

Steve

Jack in the UK · Apr 30th, 2002, 04:10 PM

generally im sure your right you should get the count, but seems can get lost and will again re oppear??? Excel floor i say...

=COUNTIF(A1:A6,"<> 0")

s-o-s · Apr 30th, 2002, 04:57 PM

Better than countif is the subtotal function which is designed for use in Filters and grouping

You have a number of options

Subtotal(2,D2:D100) will count numbers in D2-D100

Subtotal(3,D2:D100) will count characters in the range

Subtotal(9,D2:D100) will give you the sum of the values in the displayed columns.

There are 11 different values you can get these are the ones I use most...check out the Excel Help to get the others.

Apr 30th, 2002, 04:10 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	generally im sure your right you should get the count, but seems can get lost and will again re oppear??? Excel floor i say... =COUNTIF(A1:A6,"<> 0") __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 30th, 2002, 04:57 PM	#3
s-o-s Board Regular Join Date: Apr 2002 Location: Kissimmee, Florida Posts: 384	Better than countif is the subtotal function which is designed for use in Filters and grouping You have a number of options Subtotal(2,D2:D100) will count numbers in D2-D100 Subtotal(3,D2:D100) will count characters in the range Subtotal(9,D2:D100) will give you the sum of the values in the displayed columns. There are 11 different values you can get these are the ones I use most...check out the Excel Help to get the others. __________________ Hope This Helps. Sean. Digest of Homes WinXP, XL XP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 09:59 AM	#1
srmorgan Board Regular Join Date: Apr 2002 Location: Wilmington North Carolina USA Posts: 61	I am using auto filter to clean up a file. Sometimes when I filter out a variable I get a little message in the lower left hand corner of the screen stating the number of records. Sometimes I don't. Any idea why? Also, how can I get the count of the records pulled up by the filter? Thanks Steve