probably quite easy but it would be helpfil to know where the P,M,P,D,BP are.
Are they in separate cells or a string in a single cell. What is the
significance of BP, is it always zero, if so it can be ignored but it is more
complicated if it can have 2 values.

"Ade" wrote:

I am trying to record my students' grades by converting the letter grades of
individual tasks (D,M,P,BP) to number (3,2,1,0) and then summing up the
results to get a total for the unit. e.g
Student A gets P,M,P,D,BP for their tasks
this equals 1,2,1,3,0 = 6 points in total.
I have put their individual grades in a spreadsheet but it is taking forever
to convert and calculate each total individually for each student.
I would like to be able to do this as a formula in excel but am driving
myself mad trying to do it. If this makes any sense to anyone, do you have
any suggestions for a formula/formulae that I could use to achieve this?

Thanks

Ade