I have a large Excel file that takes up to 15 minutes to run due to the prevalence of sumproducts in numerous tabs.

The (very unappealing) formula is as follows:

IF(OR(ISBLANK($B152),$B152=0),0,((SUMPRODUCT(('Sales Forecast Template DP'!$D$4:$D$352=$B152)*('Sheet1'!$F$4:$F$352)*( 'Sheet1!$S$4:T$352)))+(SUMPRODUCT(('Sheet2'!$D$4:$D$352=$B152)*('Sheet2'!$F$4:$F$352)*( 'Sheet2'!$S$4:T$352))) + (SUMPRODUCT(('Sheet1'!$H$4:$H$352=$B152)*('Sheet1'!$J$4:$J$352)*( 'Sheet1'!$S$4:T$352)))+(SUMPRODUCT(('Sheet2'!$H$4:$H$352=$B152)*('Sheet2'!$J$4:$J$352)*( 'Sheet2'!$S$4:T$352)))+ (SUMPRODUCT(('Sheet1'!$L$4:$L$352=$B152)*('Sheet1'!$N$4:$N$352)*( 'Sheet1'!$S$4:T$352)))+(SUMPRODUCT(('Sheet2'!$L$4:$L$352=$B152)*('Sheet2'!$N$4:$N$352)*( 'Sheet2'!$S$4:T$352))))*$K152/12)

As you can see, the growing nature of the sumproduct range likely causes the long calculation times, as the calculations span multiple columns.
I refuse to believe that there isn't a better way of calculating this, and I appreciate any ideas you have for improving calculation speed.