Auto Filter Summary in Status Bar
 

I have a spreadsheet where I've set the Autofilter. The basic filtering is
working but it used to give me a summary in the status bar (e.g. "Showing 34
of 2388" or something like that). Now it's not working.

Having had a search through this section I thought I'd found the solution,
but it doesn't seem to be working for me. I have right-clicked on the status
bar to ensure that the SUM option is ticked and it is. I've unticked and
ticked it again, but still I'm not getting the filter data appearing.

Anything ideas?

Auto Filter Summary in Status Bar
 

Andrew, see if this will help,
http://www.contextures.com/xlautofilter02.html#Count

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2003

"AndrewJ" wrote in message
...
I have a spreadsheet where I've set the Autofilter. The basic filtering is
working but it used to give me a summary in the status bar (e.g. "Showing
34
of 2388" or something like that). Now it's not working.

Having had a search through this section I thought I'd found the solution,
but it doesn't seem to be working for me. I have right-clicked on the
status
bar to ensure that the SUM option is ticked and it is. I've unticked and
ticked it again, but still I'm not getting the filter data appearing.

Anything ideas?