Why is it exactly what you wanted?

Do you want to count how many rows have data in a selection which may include
blank cells?

The Count on the Status bar will do just that.


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 21:39:27 GMT, "sammy" wrote:

Yes thats exactly what I wanted thanks

Is there any short handway of doing without having to type in the cell eg
=COUNTA(A1:A1000)

Thanks again
Sammy

"Cimjet" wrote in message
...
If I understand your question, you can use =COUNTA(A1:A1000) adjust range
to your needs
Regards
Cimjet
"sammy" wrote in message
...
In a xl sheet I just need to count the number of rows

eg highlight and be advised there are 5 rows

hfhfdhfd
hfdhdf
gfgfg
hdfhfdh
djfdjfdj



Now I use the summation to add up the contents of say simple numbers but
I would just like to highlight a range of cells or rows and just have a
simple way of knowing how many rows there are.

Which ever is the simplest method.

Thanks in advance

Sammy