letters drive a numeric result
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?
"Gary''s Student" wrote:
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
--
Gary''s Student
gsnu200707
"mblush" wrote:
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!!
|