Convert SUMPRODUCT to SUMIFS

All the xxIF functions require ranges as arguments in certain positions, so you can't perform those INT functions, e.g.,

=SUMIF(INT($A$3:$A1083), INT($A1083), JM$3:JM1083)

... won't work.

I don't use Office365, but am certain that nothing has changed to make that formula not work. I expect you have an errant value in one of those ranges.

Which brings us to why your formulas are giving you an error. The most likely possibility is that somewhere in JM3:JM1083, there is text.

Try this modification

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)))

Or get rid of the errant values and simplify to

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

Maybe this works...

=SUMIFS(JM$3:JM1083,A$3:A1083,">="&INT(A1083),A$3:A1083,"<"&INT(A1083)+1)+SUMIFS(JN$3:JN1083,A$3:A1083,">="&INT(A1083),A$3:A1083,"<"&INT(A1083)+1)+SUMIFS(JJ$3:JJ1083,A$3:A1083,">="&INT(A1083),A$3:A1083,"<"&INT(A1083)+1)

M.

I think the solution suggested by shg in post # 4 is the best (faster)

M.