Forum Discussion
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 ...
I don't know if it would be much if any more efficient but you could try SUMIFS which should look like:
=SUMIFS($D$2:$D$481864, $E$2:$E$481864,$E2, $G$2:$G$481864,2019, $H$2:$H$481864,$H2, $I$2:$I$481864,$I2)
=SUMIFS($D$2:$D$481864, $E$2:$E$481864,$E2, $G$2:$G$481864,2019, $H$2:$H$481864,$H2, $I$2:$I$481864,$I2)
Of course - much neater than mine!