Ah, my previous formula actually does work, I just forgot a small piece:
=SUMPRODUCT(--(($C21=Data!$D$62:$D$7225)*(D$19=Data!$B$62:$B$7225)),INDEX(Data!$K$62:$V$7225,,MATCH($C$17&$C$18,Data!$K$59:$V$59&Data!$K$60:$V$60,0)))
Still entered with CTRL+SHIFT+ENTER.
If you want to use the method you provided in your previous post that alters my formula, that will work as well. The reason you won't need an array is because you are referencing one column for the MATCH portion of the formula (from K61:V61). However, if you go with the formula provided in this post, you won't need to referenced the concatenated cells from K59:V60 within K61:V61 at all.
Either way, both methods will work.
Bookmarks