Totaling rows of text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
Hi,
One way, with Name1 in A1, Name2 in A2, and Name3 in A3, enter

=COUNTA($A$1:A3) in cell A4.
 
Try:
=SUM(LEN(TRIM(A1:A10))-LEN(SUBSTITUTE(TRIM(A1:A10),"",""))
+1-ISBLANK(A1:A10))
array entered (Ctrl+Shift+Enter)
 
You must log in or register to reply here.

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

Excel Subtracting multiple columns from another column 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
IF function 3
Month wise Sum 4
Excel VBA - counting cells by colors and names to it in two different rows. 0
complex sort search and replace macro 2
Totaling columns 4
How do I count the # of unique occurences of a text in a column? 10

Back
Top