Forum Discussion
PatDools
Mar 28, 2023Brass Contributor
Speeding up a slow-running formula on large Excel dataset
I have recently found a SUMPRODUCT formula that gives me exactly the calculations I'm looking for - the issue I'm having is performance. I'm aware that the SUMPRODUCT function is 'expensive', but it ...
Patrick2788
Mar 28, 2023Silver Contributor
This was written for 'Legacy Excel' but still a good resource for what goes into calculation performance.
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-improving-calculation-performance
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-improving-calculation-performance