Try the example, then check the result.
Download the fictional material and follow the steps below. The video uses English illustrative diagrams; it does not present a live app recording. Product controls may vary by version.
Check the answer before applying the method to your own data. How we review guides ↗
Watch the complete lesson.
The video uses English illustrative diagrams; it does not present a live app recording. English captions. Product menus may differ in your account.
Quick answer. For a date column containing times, use =SUMIFS(G2:G5,H2:H5,">="&K2,H2:H5,"<"&(K2+1)). Here K2 is a true Excel date for October 22, 2026, and H2:H5 contains the constructed timestamps.
Use the fictional practice file: timestamp-orders-practice.csv, plus the independent answer check. Work in a copy. This guide stands on its own without the video.
Scope and limits. The CSV stores numeric year, month, day, hour, and minute separately. Build DateTime with DATE plus TIME; text that only looks like a date will not follow the same comparisons. Verify the two included order IDs in your workbook.
1. Build numeric timestamps
Open the fictional CSV in an Excel workbook copy. In H1 type DateTime. In H2 enter =DATE(B2,C2,D2)+TIME(E2,F2,0), fill through H5, and format H2:H5 to show both date and time. The rows should run from October 21 at 23:50 to October 23 at 00:00.
Checkpoint: H2:H5 are actual numeric date-times.
2. See why <= end date misses sales
Enter =DATE(2026,10,22) in K2. The naive end condition <=K2 includes only times at or before October 22 00:00. The two October 22 orders occur later than that boundary and are omitted.
Checkpoint: K2 represents the start of Oct 22, not its end.
3. Use the next midnight as upper bound
In an empty result cell enter =SUMIFS(G2:G5,H2:H5,">="&K2,H2:H5,"<"&(K2+1)). The first pair includes the starting midnight; the second pair excludes the next midnight. There is no need to guess a last second such as 23:59:59.
Checkpoint: Formula uses >=K2 and <K2+1.
4. Reconcile the included orders
The answer is $120 + $80 = $200. Check that the October 21 and October 23 rows are absent from the October 22 total. A displayed $200 without the correct included IDs is not enough evidence.
Checkpoint: Only SO-302 and SO-303 are included.
Verify the result
Put DateTime in H1, then =DATE(B2,C2,D2)+TIME(E2,F2,0) in H2 and fill through H5. Put =DATE(2026,10,22) in K2. The half-open SUMIFS returns $200 from SO-302 $120 and SO-303 $80. SO-301 $30 is too early; SO-304 $40 is exactly October 23 midnight and must be excluded.
If it still does not work
If the result is zero, test =ISNUMBER(H2) and inspect all four H cells. Formatting text to look like a date does not convert it to a numeric timestamp. Rebuild the DATE plus TIME formulas from the numeric parts and recheck the boundary operators.
Official sources
- SUMIFS function (checked 26 October 2026).
- DATE function (checked 26 October 2026).
- TIME function (checked 26 October 2026).
Any instructional panel without a marked actual-app capture is an illustrative diagram of the fictional exercise.
Practice downloads.
The exercise files contain invented information. Save a local copy before editing.