ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   adding text (https://www.excelbanter.com/excel-discussion-misc-queries/198686-adding-text.html)

Karen

adding text
 
Not sure if my question went through:

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

Pete Rooney

adding text
 
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



"karen" wrote:

Not sure if my question went through:

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


JMay

adding text
 
Do you mean =Counta(A1:A4) in Cell A5?

"karen" wrote:

Not sure if my question went through:

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



All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com