Thanks, I took the double minus (--) out, but I still cant' get it to work.
Can you please explain the formula to me because i cannot get it to work.
When I put in the M column (I have A column full of students' names)
A+
A
A- etc
so i subsitute the A in your formula for the m column in my worksheet.
and then have 5 marks on an A-E scale in columns b2:f2
i substitute the B2:f2 where you have d1:f1 in both places.

This is what i substituted in the end:
=SUMPRODUCT(MATCH(B2:F2,M:M,0))/COUNTm(B2:F2)
but it still does not work!
could you please explain each particular part to me then i will understand
it more fully. I am usually good with this stuff and i'm sure it's something
really simple i am doing wrong
Abi


"Max" wrote:

Think the double minus "--(...)" is not necessary here

In G1:
=SUMPRODUCT(MATCH(D1:F1,A:A,0))/COUNTA(D1:F1)
will do the job
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---