SUMPRODUCT
to speed up the opening the file, if data is not being refreshed too
frequently, you might want to set calculation to manual. Then press F9 when
you want to take the time to recalculate everything.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Tony7659" wrote:
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.
|