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.

You can use COUNTA over a column to give you this, eg:

=COUNTA(A:A)

Hope this helps.

Pete

Lisa wrote:
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.

Right click the status bar at the bottom of the Excel window and choose
Count from the list of options. Now when you select a column or filter
a range it will tell you how many items there are.

Lisa wrote:

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.

Hi Lisa: when you say records of "excel document" is it for one worksheet or
for all the worksheet in a workbook ??

"Lisa" wrote:

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.

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.

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.

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.