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.