Alpha and numeric

Is there a way to recognise an alpha entry in a range of cells and give them a corresponding numeric value in order to total them?
eg The letters C or G in a cell has a value of .20 and the letter R is zero?
Thanks in advance for any assistance

If you are talking about a single character in each cell...........this
could easily be done with a straight VLOOKUP.............if you are talking
about multiple characters in each cell, then they must first be seggregated
out individually before using VLOOKUP, unless you are talking about only a
very few combinations, which might be handled with an IF formula.

hth
Vaya con Dios,
Chuck, CABGx3


"Hammy" wrote in message
...
Is there a way to recognise an alpha entry in a range of cells and give
them a corresponding numeric value in order to total them?
eg The letters C or G in a cell has a value of .20 and the letter R is
zero?
Thanks in advance for any assistance

Dear CLR,
I thank you very much for your assistance which was of great help. I have only one character in each cell and only a few that need to be counted so your suggested IF formula worked a treat.
However I have a further complication in that some characters have a numeric value which is less than 1 eg D=1, BUT C=.20 AND G=.25
Can I still still use IF formula, and if so can you tell me the formula. My D formula is =COUNTIF(F9:AI9,"D")
Again I thank you for your time and expertise.
Regards

Hammy

Please ignore my previous request for help. I decided to try the same formula with *.20 or *.25 at the end, and as you know it works a treat.
Sorry to be so dim but I really am a novice when it comes to anything computerised.
Thank you for your original help which got me to this level of understanding simple Excel.
Regards

Hammy

You're more than welcome Hammy, glad you got it figured out and all is
working well for you now, and thanks for the feedback. These groups are
wonderful places to come to learn, and occasionally to help
others.........just read other peoples posts and the solutions, and you will
quickly see that there is usually more than one way to "skin an Excel
cat".........then you can just use the one that you're more comfortable
with.......keep coming back.........

Vaya con Dios,
Chuck, CABGx3


"Hammy" wrote in message
...
Please ignore my previous request for help. I decided to try the same
formula with *.20 or *.25 at the end, and as you know it works a treat.
Sorry to be so dim but I really am a novice when it comes to anything
computerised.
Thank you for your original help which got me to this level of
understanding simple Excel.
Regards

Hammy