Sumproct, sumif indirect with two match criteria.

Originally Posted by daddylonglegs

Try this version for 2012

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

I have change formula slightly as per below & it work perfectly.
=SUMPRODUCT(SUMIFS(INDIRECT("'"&LIST&"'!$D:$D"),INDIRECT("'"&LIST&"'!$C:$C"),$A15,INDIRECT("'"&LIST&"'!$I:$I"),F$2))