very simple question need to count number of rows

[sammy]

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

 

[Cimjet]

If I understand your question, you can use =COUNTA(A1:A1000) adjust range to
your needs
Regards
Cimjet

 

[Gary''s Student]

run this macro:

Sub rowcount()
MsgBox (Selection.Rows.Count)
End Sub

 

[Texas Nuckols]

Even Easier: Select one column of data or the range of cells you want to count
Click the arrow next to the AutoSum on the Standard toolbar, then click
Count and press ENTER.

Once you have selected the cells, you may also see "SUM = NNN" on the Status
Bar at the bottom right. If you Right Click on SUM a selection menu will
appear, Left Click on Count and it will tell you how many rows you have
selected.

 

[sammy]

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

 

[Gord Dibben]

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