View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mblush mblush is offline
external usenet poster
 
Posts: 3
Default letters drive a numeric result

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