Hi all,
I have an excel sheet with grades in ie A,B,C etc, but some have P for pass, M for merit etc.
My query is after using the countif formula to total how many grades a list of students have achieved (that is that the cells with something in have been totalled), is there a way of making some of the values added in the countif function have a different numerical weighting. eg A,B,C etc all equal 1 as they are GCSE quals, however the P and M used are from different quals some have carry a weighting of 2, others carry a value of 0.5 etc

eg- if a students has a result of 8 quals but 5 were gcses (each worth 1 qual), 2 were btec (each worth 2 quals) and 1 was a short coures(worth 0.5 quals) the total quals for this students should be 9.5 and not 8.

I have the value for each qual at the top of each indervidual column under the header (which is the name of the subject).

Can anyone help?

Regards Paul