Please use your Excel HELP (F1), you should have been able
to use "Toppers" reply.
=COUNTA(A2:A35)


"Jessica" wrote in message
...
what will the formula be. I have A2:A35 but A20 is blank i dont want it
to
count A20

"Toppers" wrote:

Look at COUNTA function.

"Jessica" wrote:

I need a formula to give total records of a column except blank cells