View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Help a novice with counting number of records

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

On Mon, 13 Nov 2006 17:41:03 -0500, TheBoz wrote:

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