Hi,

I have a sheet with many sumproducts and it takes forever to
recalculate.

Here is the basic idea, I want to calculate the number of KGS and
Dollars for each company in my list. There are dozens of companies and
the bank of sales they are looking at has 5000 rows.

both of the calculations are essentially the same except for the final
column to sum, is there a way to check the conditions I have once, then
use that calculation for both the final sums?

here is an example of the formula for KGS:
=SUMPRODUCT(('Total Pole Sales'!$C$2:$C$5412=$A$1)*('Total Pole
Sales'!$J$2:$J$5412=2004)*('Total Pole Sales'!$E$2:$E$5412='Summary
Table'!C2)*('Total Pole Sales'!G$2:G$5412))

FOR REV: =SUMPRODUCT(('Total Pole Sales'!$C$2:$C$5412=$A$1)*('Total
Pole Sales'!$J$2:$J$5412=2004)*('Total Pole
Sales'!$E$2:$E$5412='Summary Table'!C2)*('Total Pole
Sales'!H$2:H$5412))

As you can see, they are the same except for the final argument.
Any suggestions?

thanks!