In any case, try this formula instead. The results look accurate, but I'll let you be the judge. Paste into D21 as an array formula and confirm with CTRL+SHIFT+ENTER. Drag across and down to fill:
![]()
=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)))
Bookmarks