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.