adding text

  • Thread starter Thread starter karen
  • Start date Start date
K

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
 
=COUNTA(A1:A6)
John (A1)
Sara (A2)
Kim (A3)
Pam (A4)
dek (A5)
Paul (A6)

hope this helps
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding text 2
Remove Repeats in a Column 3
Count column b if column a equal cell value 7
Excel VBA - counting cells by colors and names to it in two different rows. 0
Getting Text data using the Data - Subtotal feature 1
Macro to add numbers in a text string 5
How can I match these sheets? 6
i need an excel wizard 2

Back
Top