Totaling rows of text

C

clms

I have rows of last names in a single column, at the end of the column i
would like a total number of names and i would like that number updated each
time i add or subtract a name. What formulat should i use to get this ?
 
K

Ken Hudson

Hi,
One way, with Name1 in A1, Name2 in A2, and Name3 in A3, enter

=COUNTA($A$1:A3) in cell A4.
 
G

GerryK

Try:
=SUM(LEN(TRIM(A1:A10))-LEN(SUBSTITUTE(TRIM(A1:A10),"",""))
+1-ISBLANK(A1:A10))
array entered (Ctrl+Shift+Enter)
 
Top