Hey all need to get a sum of a couple of columns in excel 2003 but the catch is if one field has a letter it needs to use a predefined value.

IE:

90
C
A <--- Sum this column use 75 for C 85 for B and 95 for A
90
------

i need a general formula some columns might not have letter grades some might ONLY have letter grades