Reply to thread

Message: [QUOTE="Mike H, post: 3275479"] Hi, A different approach. You didn't say what your grade letters/numeric equivalent are so this formula has 15 grades F- to A+ and in ascending order each is assigned a numeric value of 1 to 15 so you should be able to modify it. Just remember that you must keep the formula 'Balanced' 10 grades * 10 numbers etc. You can substitute AVERAGE with MIN or MAX. I haven't worked out (yet) why SUM isn't working but I will but unfortunately have no more time this evening. This ARRAY formula will now averaged the numeric equivalent of the 3 grades in your range =INDEX({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15},AVERAGE(MATCH(B12:D12,{"F-","F","F+","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"},0))) This is an array formula which must be entered by pressing CTRL+Shift+Enter 'and not just Enter. If you do it correctly then Excel will put curly brackets 'around the formula {}. You can't type these yourself. If you edit the formula 'you must enter it again with CTRL+Shift+Enter. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. [/QUOTE]