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))
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))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks