Have a formula that has been working for me for several years. Recently, I upgraded from Excel for Mac 14.5.3 to Office 365 and my sumproduct formula's are now producing a #value!.

Maybe a good time to upgrade the formula to SUMIFS. Here is my current formula. Anyone have a good conversion to SUMIFS? Or a solution to the #value! in office 365?

SUMPRODUCT((INT($A$3:$A1083)=INT($A1083))*(JM$3:JM1083))+SUMPRODUCT((INT($A$3:$A1083)=INT($A1083))*(JN$3:JN1083))+SUMPRODUCT((INT($A$3:$A1083)=INT($A1083))*(JJ$3:JJ1083)))

Thank you in advance!