counting words and assigning a numeric value

K

KDC

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
 
D

Dave

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
 

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

Header Roman Numeral to Regular Numbers 1
How to count the numbers in a Word document? 0
Remove Identical words 0
Excel - Wich Function should I use? 1
Multiple IF Statement in Word 5
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Assign Formatted Block of Text to Theme 0
Trying to create custom labels from an csv file + Need items numerically counted out 0

Top