I have the following formula in Cells G69:G439.

=IF($D$53="Service Code",SUMPRODUCT(($D$52='Actuals Input'!$AG$4:$AG$27885)*('Actuals Input'!$I$4:$I$27885>700000)*('Actuals Input'!$L$4:$L$27885<>"HI1")*($F69='Actuals Input'!$X$4:$X$27885)*('Actuals Input'!$C$4:$C$27885)),SUMPRODUCT(($D$52='Actuals Input'!$AG$4:$AG$27885)*('Actuals Input'!$I$4:$I$27885>700000)*('Actuals Input'!$L$4:$L$27885<>"HI1")*($F69='Actuals Input'!$V$4:$V$27885)*('Actuals Input'!$C$4:$C$27885)))

I would like to replace this formula with something more efficient and faster at calculating.

Can anyone please help?