Record Counts

L

Lisa

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.
 
P

Pete_UK

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

=COUNTA(A:A)

Hope this helps.

Pete
 
L

Lori

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.
 
R

romelsb

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

Epinn

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

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.
 
R

romelsb

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...
 
E

Epinn

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

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...
 
Top