Filters

[srmorgan]

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]

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]

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.