excel filtering

[Guest]

how can I see how many rows meet my filter criteria in excel

 

[Guest]

Use this function:

SUBTOTAL(3,A2:A100)

 

[Guest]

Lower left hand corner of screen will say something like...
'25 of 187 records found' immediately after applying the filter
HTH,
Gary Brown
using Excel XP

 

[Gord Dibben]

Gary

Not necessarily.

From Debra Dalgleish......................

Normally, after you have applied an AutoFilter, the Status Bar shows a count
of visible records. Sometimes it just says, "Filter Mode." This can happen
when your list has many formulas. There are articles in the Microsoft
KnowledgeBase that explain:

XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode" Q213886)
XL: AutoFilter Status Bar Message Shows "Filter Mode" (Q189479)


The Status Bar will also show "Filter Mode" if anything is changed in the
list, after a filter has been applied. For example, if you format a cell, or
type a number in one of the records, the 'Filter Mode' message will appear in
the Status Bar.

End Debra.................................

The workaround is as Gary Rowe suggested......The SUBTOTAL Function.

Gord Dibben Excel MVP

 

[Guest]

Gary,
I've tried this, but the number also includes my criteria range, (in my
case, always 4 extra records). How do I eliminate the criteria range from the
count?

 

[Dave Peterson]

I've never seen this include the criteria range (headers????).

When that message shows, it's only counting the rows that are visible after your
filter has been applied.