Thanks.

Some of these Microsoft bugs or deficiencies seem to stay around for quite a
long time without being fixed. Do they ever get fixed, I wonder??? Or maybe
it's just been too long since I've upgraded. (I'm not looking forward to the
upgrade to Office 2007, with its redesigned menus and ribbons, where I'll
have to relearn where every feature is.)

"Luke M" wrote:

You are correct, sometimes its there, sometimes not. It's a known error w/ XL.
Alternatively, you could use a header cell somewhere with a subtotal
function like
=SUBTOTAL(3,A2:A65000)
Note that you should make it check a column that always contains data.
Subtotal doesn't count filtered rows, so could return the same thing as the
record count without you having to select cells.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eric_NY" wrote:

Thanks. I never knew about that feature.

But what happened to the record count on the left side at that same screen
level? I'm pretty sure I recall that it used to, or that it sometimes,
displays record count without being asked.

"rrcd124" wrote:

Over to the Right side of the screen same level as "filter mode" you'll see
light shaded blocks......right mouse click and select "count" vs Sum....etc.
But then you'll have to highlight what you want to count after it is
filtered...hope this helps

Peter

"Eric_NY" wrote:

As I recall, Filter used to show a count of records at the bottom of the
screen after applying a new filter value. But now it doesn't - all I see is
the legend "Filter mode".

How can I see the record count?

I'm using Excel 2003.

Thanks.