Yes, I was aware of Lisa's request. I included the points for *all* readers. This thread will be archived and users will Google/search ....... It is a good idea to be comprehensive for a subject as general as this one, regardless of the original poster's needs.

Epinn

"romelsb" wrote in message ...
good point Epinn...but "bottom of your screen it will tell you found 2 0f 2
Records Found" is Lisa's wish...i also waiting to find out...

"Epinn" wrote:

I would like to point out that the result may be different from Pete's method (COUNTA) and Lori's method (AutoCal) if you have hidden rows. COUNTA includes all hidden (manual and filtered) rows while AutoCal counts the records on the screen that you can see.

There is a third method - SUBTOTAL (3, 103 etc. etc.) if you want to ignore certain type of hidden rows and use the result in a formula. See Excel Help for details.

One more point - don't forget to subtract header rows if any.

Feel free to correct me if I am wrong.

Epinn

"Lisa" wrote in message ...
Wondering if there is a way to indicate the Number of Records in an excel
document in a particular area without using the filter option. So what I
mean is - when you filter on a field for a piece of information down in the
bottom of your screen it will tell you found 2 0f 2 Records Found. Is there
a way to have a number there indicating how many records are on the sheet?

Any help you can provide would be great.

Thanks in advance.