Alpha and numeric

[Hammy]

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

 

[CLR]

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

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?

 

[Hammy]

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
Regard

Hammy

 

[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

 

[CLR]

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

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.