array formula

You can change the index range ('Results Key'!$D$1:$D$6), but arrays inside SUMPRODUCT() need to be the same size. ie. in your test5 file, "$B$1:$B$6", "$C$1:$C$6", and "$A$3:$A$23" must match.

So should it be A3:A8? That refers to the results page right? Or is it results key A1:A6? I think that's where the formula is messing up.