Changing SUMIFS to SUMPRODUCT

[IronSharpie]

I have been fruitlessly trying to swap a SUMIFS formula over to a SUMPRODUCT and have finally given up. Can anyone help me convert this? I have read several posts on how it works but something is working out.

=SUMIFS('M:\DAC Leadership\Current Tools\2018\2 Feb\Kronos\[February Kronos Hours.xlsx]2.1'!$D$2:$D$33,'M:\DAC Leadership\Current Tools\2018\2 Feb\Kronos\[February Kronos Hours.xlsx]2.1'!$A$2:$A$33,A4)

 

[RoryA]

Welcome to the forum.

It should be:

=SUMPRODUCT(--('M:\DAC Leadership\Current Tools\2018\2 Feb\Kronos\[February Kronos Hours.xlsx]2.1'!$A$2:$A$33=A4),'M:\DAC Leadership\Current Tools\2018\2 Feb\Kronos\[February Kronos Hours.xlsx]2.1'!$D$2:$D$33)