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
RayH - Jan 21, 2015 at 08:53 PM
Related:
- Counting Words, Names as Number Values
- My contacts list names - Guide
- How to count names in excel - Guide
- Based on the values in cells b77 b81 - Excel Forum
- Stop counting days in excel when status is changed ✓ - Excel Forum
Jan 21, 2015 at 08:15 PM
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' ?
Jan 21, 2015 at 08:53 PM
=COUNTA(B2:B10)
Set the range as appropriate.