Counting Words, Names as Number Values
Closed
nexgenpro
RayH - Jan 21, 2015 at 08:53 PM
- Posts
- 2
- Registration date
- Wednesday January 21, 2015
- Status
- Member
- Last seen
- January 21, 2015
RayH - Jan 21, 2015 at 08:53 PM
Related:
- Counting Words, Names as Number Values
- How to count total names in excel - Guide
- Excel - Count 2 values in one column and 1 value in other - How-To - Excel
- Can the formula COUNTA / COUNT exclude 0 values? ✓ - Forum - Excel
- How two count values matching other values ✓ - Forum - Office Software
- Counting values in Multiple ComboBox's ✓ - Forum - Office Software
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.