With SUMIFS, the sum range goes first, then followed by each criteria range/criteria combo
Try:
=SUMPRODUCT(SUMIFS(INDIRECT("'"&ROW(INDIRECT("1:21"))&"'!D"&ROWS($A$2:$A3)),INDIRECT("'"&ROW(INDIRECT("1:21"))&"'!$F$45"),"Condition1",INDIRECT("'"&ROW(INDIRECT("1:21"))&"'!$K$45"),"Condition2"))
Bookmarks