Compute total score based on student number

Thanks kelshaer.

Actually, I have one more question.

Why am I unable to modify the formula.

When I simply click on the formula and then click elsewhere, it returns the result "n/a"

It appears that the brackets go missing and then it stuffs up. The brackets are { and }

I want to change the range on the formula but can't do this!

It's something to do with the countif function but I can't work out exactly what!

Originally Posted by sinth

Thanks kelshaer.

Actually, I have one more question.

Why am I unable to modify the formula.

When I simply click on the formula and then click elsewhere, it returns the result "n/a"

It appears that the brackets go missing and then it stuffs up. The brackets are { and }

I want to change the range on the formula but can't do this!

It's something to do with the countif function but I can't work out exactly what!

Hi sinth,

it's because the first formula is an array formula. When you type it in (or edit it in your case) you must commit it using the key combination of Ctrl-Shift-Enter rather than the usual <enter>. If you do this correctly then Excel will wrap curly braces { } around the formula, but you must not type these yourself. You can then copy the formula down the column in your usual way.

Hope this helps.

Pete

Yes, it does help.

I learnt that the hard way, heh I was trying to put the brackets in myself!

Thanks very much again!