summing text converted to numbers

Hello,   I am in the process of setting up an attendance "tracker" and need some direction with a formula.   I need to convert text codes into numerical values and then sum them together.    Th...