letters drive a numeric result

M

mblush

one of the segments to this worksheet includes 12 boxes where users would
enter one of 4 letters. E,S,O or R. E being the most valuable then S then O
then R. Im trying make excell produce a numeric result (1 - 100) based on how
many of the boxes are filled with one of the four letters.
I had though to use a COUNTIF formula but that doesnt seem to work.
Please help!!
 
G

Gary''s Student

You actually were correct. use:

=COUNTIF($A$1:$A$12,"E")
=COUNTIF($A$1:$A$12,"S")
=COUNTIF($A$1:$A$12,"O")
=COUNTIF($A$1:$A$12,"V")

to count the respective letters. Adjust the block-of-cells to match your
structure
 
M

mblush

Great! knew it was a small thing! now, lets say I wanted to place a value to
the letters, for instance;
E = 4
S = 3
O = 2
R = 1
Can I make the COUNTIF function do this automatically? or is there another
function I should apply to the result of the COUNTIF?
 
M

mblush

Actualy I have that figuered out as well! thanks alot! occassionally the ole'
noodle needs a Jumpstart!
 
Top