Showing Record count when filtering

Try this:

SUBTOTAL(3,A1:A500)

I think you mean on the bar at the bottom, same area as NUM, but on the left. I just tried mine,a nd it shows number of records out of total. But I haven't found any setting that changes that.

Just a note, if you change pages (or programs), the record count disappears. You need to choose another filter item for the record count to appear. Maybe the VP is looking at other spreadsheets/other programs?

If the formula solution does not suit; you can go to tools>options>calculation and check the manual box.
This will display the results in the status bar.

Just ran across this in an old message board:

Posted by Ann Druery on July 15, 2001 6:17 PM

Doing a survey I have numbers from 0 to 5 to enter into different columns. Previously the Autofilter when I selected a number I'd entered in the selected column, it would give me the total number (not sum) of that selected i.e. there are 56 of 2. This would show on the lower left hand side of my screen. This facility has disappeared. It is only showing the sum of the figure selected. Can anyone assist me to regain this facility? I thank you in anticipation.

Re: Autofilter
Posted by Ivan F Moala on July 16, 2001 3:38 AM

Try running this macro to reset the
statusbar;
Sub E()
Application.StatusBar = False
End Sub

HTH

Ivan

If you need a temporary answer, use this:

=SUBTOTAL(3,F2:F749)

(modify your range as needed - this actually does a count rather than sum)

Or one other discussion:

Status bar changes upon filtering
Posted by Mike on October 03, 2001 10:28 AM

In creating reports I quite often use the autofilter function. Sometimes when I filter a list, the status bar shows the number of items found, out of the total number searched (14 of 23 found), but sometimes it just say, Filter Mode.
Can anyone tell me how to change this from one to the other?

Re: Status bar changes upon filtering
Posted by Mark W. on October 03, 2001 11:10 AM

It's been my experience that when your list contains
formulas (especially volatile ones) that you can
lose the count. I find that Excel's AutoCalculate
feature can be used quite effectively as a
"work around" for this problem. Just right
mouse click on the Status Bar, choose "Count" and
select the cells in one your list columns (excluding
the header row) prior to the application of an
AutoFilter.

Re: Status bar changes upon filtering
Posted by Mike on October 03, 2001 12:06 PM

Thanks, that's what I've been doing for a workaround. I was hoping that someone had found a way to change it back. When you have a lot of items to filter and report, it's rather time consuming to continually go back and hilight columns.

Re: Status bar changes upon filtering
Posted by Mark W. on October 03, 2001 12:46 PM

Yeah, it can be a hassle... fortunately, a Defined
Name can be created to minimize the hassle.
Just select a cell in your list (I'll assume that
it's A2), choose the Insert | Name | Define menu
command, enter a name (I'll use "Data_Range") into
the "Names in workbook" field, and the reference,
=Sheet1!A$2:A$65536,in the "Refers to" field, and
press [ OK ]. Now with any cell in your list
selected you can choose "Data_Range" from the Name
Box located on the left-hand side of the Formula
Bar. Or, if you prefer, you can choose "Data_Range"
from the Go To list using Control+G.

==============

BTW, this has been benefiticial for me, just trying to look for an answer.