The November report needs all activity on the 30th, including a record entered at 23:30. Use the start of December as the cutoff so the last day stays in scope.

Enter real dates and times

In A2:A5 enter October 31 at 23:50, November 1 at 00:00, November 30 at 23:30, and December 1 at 00:00, all in 2026. Put 3, 12, 8, and 7 in B2:B5. Set E2 to =DATE(2026,11,1) and E3 to =DATE(2026,12,1).

The November time interval includes the 1st at midnight and the 30th at 23:30.

Illustrated timestamp boundaries. The next month’s first moment is outside the interval.

Check the start and the next month’s first moment

=SUMIFS(B2:B5,A2:A5,">="&E2,A2:A5,"<"&E3)

Expect 20. The November 1 midnight record and the late November 30 record count. December 1 at midnight is outside the range. If an import yields a different result, check whether the timestamps are stored as text and whether they use the reporting time zone.

The included records total 12 plus 8, or 20.

Illustrated reconciliation. Check the two exact midnight boundaries.

Microsoft’s SUMIFS function reference