Help a novice with counting number of records

[TheBoz]

I would like to have the total number of records printed when I print
out the data. The records contain names and addresses only, I would
like to have the number of records I have printed, and this will
change monthly. This should be a simple matter but since I am a novice
with Excel I'm having a hard time doing this. Would some kind soul
please help?

Thanks for your time
TheBoz

 

[David Biddulph]

Try the COUNTA() function.

 

[Gord Dibben]

TheBoz

You could enter this formula in a cell near the top of your print range of
records.

="There are" & COUNTA(A:A) & " Records"


Gord Dibben MS Excel MVP

 

[TheBoz]

Try the COUNTA() function.

This worked for me. I didn't know what to put in the () but I kept
trying until I got it.

Once again thanks
TheBoz