Sumproct, sumif indirect with two match criteria.

Originally Posted by Ace_XL

maybe..

=SUMPRODUCT(SUMIFS(INDIRECT("'"&LIST&"'!D:D"),INDIRECT("'"&LIST&"'!C:C"),A15,INDIRECT("'"&LIST&"'!I:I"),F$2))

and drag across

Yes ACE_xl. Thanks.