How do you count rows in excel without numbers in it?

Use ROWS

=ROWS(A1:A20) will return 20. Add details if you need more help or if this is not what you are trying to do