adding text

K

karen

Not sure if my question went through:

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

Pete Rooney

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
 
Top