I have a workbook with 2,600 SUMPRODUCT formulas, each looking for 5
conditions as follows:

=SUMPRODUCT((PLANS!$A$5:$A$25000=TEXT($A9,"#"))*(P LANS!$B$5:$B$25000=$A$4)*(PLANS!$E$5:$E$25000=$D$3 )*(PLANS!$F$5:$F$25000=D$4)*(PLANS!$K$5:$K$25000=$ E$3),PLANS!$H$5:$H$25000)

The sheets "PLANS" is an external database that refreshes from the company
server. The problem is that opening the file takes a long time. How can I
speed up the process? Tony.