Counting Words, Names as Number Values

Closed
nexgenpro
Posts
2
Registration date
Wednesday January 21, 2015
Status
Member
Last seen
January 21, 2015
- Jan 21, 2015 at 07:22 PM
 RayH - Jan 21, 2015 at 08:53 PM
Hi,
Ive been searching for a way to count a list of names as a number. I currently have to place a 1 in a column next to the list of names. And have formulated a cell to count the 1's. What I want is for excel to add the names as a total when the next name is added to the list in the same column.
Hence eliminating the need for a boring looking column of '1's'
Any helpers?

Thanks in advance.

1 reply

Can we see some sample data please?
0
nexgenpro
Posts
2
Registration date
Wednesday January 21, 2015
Status
Member
Last seen
January 21, 2015

Jan 21, 2015 at 08:15 PM
I don't have a sample to show as I'm writing on a mobile device. But please allow me explain in an example:
Column A, B, & C.
Column A is where a place a number 1.
Column B is where I write the name of a person I.e. John smith in the same row.
Each time I write a new name in Column B, I place another number 1 in Column A, same row.
Column C1 is where I create a formula sum to add the total number of '1's from Column A
So, if I have a list of 10 names in column B, Column A also has a column of number 1's.

How do still formulate C1 to total 10 without having to even have Column A?

Is there a way to sum words as a 'equal to 1' ?
0
RayH > nexgenpro
Posts
2
Registration date
Wednesday January 21, 2015
Status
Member
Last seen
January 21, 2015

Jan 21, 2015 at 08:53 PM
try using:

=COUNTA(B2:B10)

Set the range as appropriate.
0