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

"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!!