ExcelBanter - adding text

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/198684-adding-text.html)

Karen

adding text

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
--
keb

Pete_UK

adding text

Use COUNTA(range).

Hope this helps.

Pete

On Aug 13, 3:44*pm, karen wrote:
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
--
keb

MillyD

adding text

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

hope this helps

"karen" wrote in message
...
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
--
keb

All times are GMT +1. The time now is 02:21 AM.