## Shortening Calculation Time for Multiple Sumproducts

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.