adding text

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

karen

Not sure if my question went through:

How do I add rows of text?
example
Pam
Joe
Bob
sara
Total: 4
 
Hi, Karen,

Use the =COUNTA function.

So, if your names are in cells a1:a4, =COUNTA(A1:A4) would return 4

You use =COUNT to count numeric values and =COUNTA to count non-numeric
values in any given range.

Hope this helps

Pete
 

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
Adding Problem 6
Comparing Data on 2 sheets 1
keeping groups when filtering 2
Counting the number of times more than 1 variable occurs 5
How do I number rows automatically? 1
Mixed Data in column 5
Compare Rows and delete duplicate records 3

Back
Top