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
Bookmarks