adding text

[karen]

hello - I am trying to total the number of rows I have - how do I do that
with Text in it?

Example
John
Sara
Kim
Pam
Total: 4

 

[Pete_UK]

Use COUNTA(range).

Hope this helps.

Pete

 

[MillyD]

=COUNTA(A1:A6)
John (A1)
Sara (A2)
Kim (A3)
Pam (A4)
dek (A5)
Paul (A6)

hope this helps