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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks