I can quickly spot where the problem is:
it's not taking into account week 73 hours 8
Which shall be used in normalized week 25 (a representation of standard weeks 71.08 - 74).
so the condition in I2:Formula:
=SUMIFS(D:D,C:C,">"&H2,C:C,"<"&H3-1)
is too strong.
Seems thatFormula:
=SUMIFS(D:D,C:C,">"&H2,C:C,"<="&H3-1)
Test it and observeif it behaves better
![]()
Bookmarks