Spicehead
asked on
Changing Array function to D function in Excel 2003
I'm trying to change array function to D function in Excel 2003 for our inventory.
As you can see in the attached file, sums of 4 arrays create inventory.
Array seems to be running very slow when there are a lot of items to be calculated.
And I got more than 1000 lines to be calculated.
It takes more than 1 minute to do the calculation everytime I add a line.
As far as I know =dsum runs much faster than =sum of arrays.
Not sure it's possible in this case though.
Any help would be appreciated.
Inventory7.xls
As you can see in the attached file, sums of 4 arrays create inventory.
Array seems to be running very slow when there are a lot of items to be calculated.
And I got more than 1000 lines to be calculated.
It takes more than 1 minute to do the calculation everytime I add a line.
As far as I know =dsum runs much faster than =sum of arrays.
Not sure it's possible in this case though.
Any help would be appreciated.
Inventory7.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.