ExcelBanter - counting words and assigning a numeric value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - counting words and assigning a numeric value (https://www.excelbanter.com/excel-worksheet-functions/226554-counting-words-assigning-numeric-value.html)

KDC

counting words and assigning a numeric value

I need to count words (6 different words) in a column; then assign a numeric
value to each word. I will then sum the different word values. Can you help

Jacob Skaria

counting words and assigning a numeric value

Can you give us an example
--
If this post helps click Yes
---------------
Jacob Skaria

"KDC" wrote:

I need to count words (6 different words) in a column; then assign a numeric
value to each word. I will then sum the different word values. Can you help

Dave

counting words and assigning a numeric value

Hi KDC,
Perhaps you can count the words using Countif, then just do the math on each
result.
=COUNTIF(A2:A100,"=Word a")
=COUNTIF(A2:A100,"=Word b")
=COUNTIF(A2:A100,"=Word c")
etc

"KDC" wrote:

I need to count words (6 different words) in a column; then assign a numeric
value to each word. I will then sum the different word values. Can you help

All times are GMT +1. The time now is 04:12 PM.