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.