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.
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.
Last edited by mlcb; 04-03-2017 at 05:10 PM. Reason: adjust ranges
Marcelo Branco
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks