Excel SUMIF After a Date: Formula and Examples

Formulas & functions · Updated November 19, 2026

To sum values for dates strictly after a cutoff in Excel, use =SUMIF(A2:A100,">"&DATE(2024,1,1),B2:B100), where column A contains dates and column B contains amounts. Use >= instead of > to include the cutoff date itself; the key is to join the comparison operator to a real Excel date value.

How SUMIF applies a date condition

SUMIF adds numbers from one range when corresponding entries in another range meet a single condition. Its arguments are SUMIF(range, criteria, [sum_range]): the range to check, the condition to apply, and—optionally—the cells to add. For date-based totals, the date column is the condition range and the numeric column is the sum range. If you omit the sum range, Excel adds qualifying cells in the condition range itself, which is usually not what you want when the dates and amounts are in different columns.

Assume A2:A6 contains Jan 1, Jan 5, Jan 10, Jan 15, and Jan 20, 2024, while B2:B6 contains 10, 20, 30, 40, and 50. With those dates in A2:A6 and amounts in B2:B6, this formula sums amounts strictly after Jan 10:

=SUMIF(A2:A6,">"&DATE(2024,1,10),B2:B6)

The result is 90: it adds 40 and 50 for Jan 15 and Jan 20. Jan 10 is excluded because the operator is greater than, not greater than or equal to. This simple distinction is often the whole answer to “Excel SUMIF after date?”

Build the date criterion correctly

Excel stores ordinary dates as serial numbers, even though the cells display familiar calendar dates. A comparison such as “after Jan 10” therefore needs to compare numeric date values, not rely on how a date happens to look on screen. The criterion argument is text, so a comparison operator is normally joined to a date value with the ampersand character.

  • ">"&DATE(2024,1,10) means later than Jan 10, excluding that date.
  • ">="&DATE(2024,1,10) means Jan 10 or any later date.
  • "<"&DATE(2024,1,10) means earlier than Jan 10.
  • "<="&DATE(2024,1,10) means Jan 10 or an earlier date.

With dates in A2:A6 and amounts in B2:B6 as above, this version includes Jan 10 and all later dates:

=SUMIF(A2:A6,">="&DATE(2024,1,10),B2:B6)

It returns 120: 30 + 40 + 50. The DATE(year,month,day) function avoids ambiguity about whether a typed date such as 1/10/2024 means January 10 or October 1 in a particular regional setting. It also makes the intended year, month, and day explicit.

Use a cutoff date stored in a cell

A date in a worksheet cell is convenient when users need to change the reporting cutoff without editing the formula. Put a genuine Excel date in E1—for example, Jan 10, 2024—and refer to it in the criterion. The operator still needs to be joined to the cell reference. Typing ">E1" as the criterion would search for text beginning with those characters rather than compare against the value in E1.

With dates in A2:A6, amounts in B2:B6, and the cutoff date in E1, use:

=SUMIF(A2:A6,">"&E1,B2:B6)

For the sample data with E1 set to Jan 10, 2024, the result is 90. To include the cutoff, with the same cell layout and E1 value, use:

=SUMIF(A2:A6,">="&E1,B2:B6)

That returns 120. If the formula will be copied across or down, lock the cutoff reference as needed. With dates in A2:A6, amounts in B2:B6, and E1 holding the cutoff, the fixed-reference version is:

=SUMIF(A2:A6,">="&$E$1,B2:B6)

For a single formula entered in one cell, relative versus absolute references do not change the result. The dollar signs matter when copying the formula, because they keep the cutoff pointing to E1.

Choose between after and on or after

People use “after a date” in two different ways. In a strict comparison, the cutoff date is excluded; in everyday reporting, someone may mean “starting on this date,” which includes it. Pick the operator based on the rule you need, rather than on the wording alone. This matters for sales periods, invoice deadlines, attendance records, and any total where a boundary day must be counted consistently.

With dates in A2:A6 and amounts in B2:B6 as in the example, the strictly-after formula returns 90, while the on-or-after formula returns 120. The 30 difference is the amount recorded on Jan 10. Checking one boundary row by hand is a useful way to verify that the operator matches the intended policy.

Also decide whether a “through” date includes its whole calendar day. If the source contains date-and-time values, a cutoff that looks like Jan 10 may represent midnight at the start of that day, not the end. The next section explains why that can change the total.

Dates that include times

Excel stores a time as a fraction of a day and combines it with the date number. A value displayed as Jan 10 may therefore be Jan 10 at 3:00 PM, even if the cell format hides the time. Comparing that value to Jan 10 at midnight treats the afternoon entry as greater than the cutoff. As a result, a strict > comparison against a date can include later times on the same calendar day.

For example, assume A2:A4 contains Jan 10 at 12:00 AM, Jan 10 at 3:00 PM, and Jan 11 at 9:00 AM, and B2:B4 contains 10, 20, and 30. With those date-times and amounts, this formula compares every value with midnight at the start of Jan 10:

=SUMIF(A2:A4,">"&DATE(2024,1,10),B2:B4)

The result is 50: it includes the 3:00 PM Jan 10 entry and the Jan 11 entry, but not midnight exactly. If “after Jan 10” means from Jan 11 onward, use the next day as the inclusive boundary. With the same A2:A4 and B2:B4 layout, the formula is:

=SUMIF(A2:A4,">="&DATE(2024,1,11),B2:B4)

It returns 30. This boundary technique is often clearer than trying to specify the last instant of a day, and it also works if the data has seconds or fractions of a second.

Sum values within a date range

SUMIF handles one condition. To sum between a start date and an end date, use SUMIFS, which supports multiple conditions. A common inclusive range uses a greater-than-or-equal condition for the start and a less-than-or-equal condition for the end. With dates in A2:A6 and amounts in B2:B6, this totals Jan 10 through Jan 20, including both endpoints:

=SUMIFS(B2:B6,A2:A6,">="&DATE(2024,1,10),A2:A6,"<="&DATE(2024,1,20))

The result is 120: the amounts for Jan 10, Jan 15, and Jan 20. Notice that SUMIFS puts the sum range first, unlike SUMIF. Its criteria range and sum range should also have matching dimensions.

When the data includes times and the end date should count in full, use the day after the end date as an exclusive upper bound. With the same date-time range and amounts, this pattern sums all entries on Jan 10, including any time on that day:

=SUMIFS(B2:B4,A2:A4,">="&DATE(2024,1,10),A2:A4,"<"&DATE(2024,1,11))

For the example rows of Jan 10 at midnight (10), Jan 10 at 3:00 PM (20), and Jan 11 at 9:00 AM (30), it returns 30. The upper boundary excludes Jan 11 at midnight and everything after it, while retaining every timestamp on Jan 10.

Common problems and how to fix them

If the answer is zero or too small, first check that the dates are real Excel values. Dates imported from a CSV or copied from a website can be text, even when they look correctly formatted. A quick clue is that changing the cell’s number format may not change the display as expected, or comparisons may behave differently from neighboring dates. Convert or re-import the values as dates before relying on date criteria; changing the appearance alone does not necessarily convert text into a date number.

  • Wrong operator: Replace > with >= if the cutoff day belongs in the total. Check the boundary amount against the result.
  • Wrong range: The date range must point to the date cells, and the sum range to the values to add. Keep their row positions aligned.
  • Hidden time values: Format or inspect a sample cell to see whether it contains a time. Use the next-day boundary when the intention is to exclude the entire cutoff day.
  • Inconsistent data: Blank date cells, text dates, or amounts stored as text can cause records not to behave as expected. Clean the source columns and confirm amount cells are numeric.
  • Regional date interpretation: Ambiguous typed dates may be read differently depending on settings. Use DATE(year,month,day) or enter the cutoff in a clearly recognized date format.

In Excel for Microsoft 365 on Windows, the same formulas work in the desktop app and Excel for the web. The formulas also work in Excel for Mac; the date comparison logic is the same. A copied formula may use a different list separator if the computer’s regional settings require semicolons, but the examples here use the standard comma separators specified for Excel formulas.

When SUMIF is the right choice

Use SUMIF when there is one date condition, such as “sum amounts later than the cutoff.” Use SUMIFS when you need a date window or additional conditions—for example, dates after a cutoff and a matching department. The functions are built for conditional totals and are usually easier to maintain than manually filtering rows and adding visible results.

For a quick check or a one-off analysis, filtering the date column and using the status bar to inspect selected numeric cells may be enough, but that does not create a reusable formula total. A PivotTable is a more suitable alternative when the goal is to summarize many categories by month, customer, or other fields and explore the data interactively. It is not a replacement for a simple formula when the worksheet needs one live total that updates as criteria change.

Frequently Asked Questions

How do I sum values after a date in Excel?
With dates in A2:A100 and amounts in B2:B100, use =SUMIF(A2:A100,">"&DATE(2024,1,1),B2:B100) to sum dates strictly later than Jan 1, 2024. Substitute the date and ranges that match your sheet.

How do I include the date in the SUMIF total?
Change the criterion from greater than to greater than or equal to. With dates in A2:A100 and amounts in B2:B100, use =SUMIF(A2:A100,">="&DATE(2024,1,1),B2:B100). This includes Jan 1 as well as later dates.

Can SUMIF use a date in another cell?
Yes. If A2:A100 contains dates, B2:B100 contains amounts, and E1 contains a valid Excel date, use =SUMIF(A2:A100,">"&E1,B2:B100). Join the comparison operator to the cell reference with &.

Why does SUMIF include some entries on the cutoff date?
The date cells may include times. A timestamp later than midnight on the cutoff date is numerically greater than the date at midnight. To start with the day after the cutoff, compare against the next day using an inclusive boundary.

How do I sum between two dates?
Use SUMIFS with one condition for the start and another for the end. Make each endpoint inclusive with >= and <=; if timestamps are present and the end date should count in full, use a less-than condition for the day after the end date.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.