How do I get the filter mode to show the good row count?
 

I filter worksheets extensively, and I always used to have the count appear
on the status bar on the bottom left showing me how many rows met my
criteria. All of a sudden, all it says is 'fitler mode', and i'm going
crazy counting by hand!

Please let me know how to set the page to provide the counts.

How do I get the filter mode to show the good row count?
 

Debra Dalgleish explains it and gives some alternatives:
http://contextures.com/xlautofilter02.html#Count

vera wrote:

I filter worksheets extensively, and I always used to have the count appear
on the status bar on the bottom left showing me how many rows met my
criteria. All of a sudden, all it says is 'fitler mode', and i'm going
crazy counting by hand!

Please let me know how to set the page to provide the counts.

--

Dave Peterson

How do I get the filter mode to show the good row count?
 

Thank you! Thank you! Thank you!

"Dave Peterson" wrote:

Debra Dalgleish explains it and gives some alternatives:
http://contextures.com/xlautofilter02.html#Count

vera wrote:

I filter worksheets extensively, and I always used to have the count appear
on the status bar on the bottom left showing me how many rows met my
criteria. All of a sudden, all it says is 'fitler mode', and i'm going
crazy counting by hand!

Please let me know how to set the page to provide the counts.

--

Dave Peterson