You can use the following formula in Excel to sum the values in one column where the corresponding date in another column is greater than a specific date:
=SUMIF(A2:A12, ">"&E1, B2:B112)
This particular formula calculates the sum of values in the range B2:B12 only where the corresponding cells in the range A2:A12 are greater than (i.e. “after”) the date in cell E1.
The following example shows how to use this formula in practice.
Example: Sum if Date is Greater Than Specific Date in Excel
Suppose we have the following dataset that shows the number of sales made on various dates at some company:
Suppose we would like to calculate the sum of all sales that occurred after 3/1/2023.
We can specify this cutoff date in cell E1 and then type the following formula into cell E2 to calculate the sum of all sales that occurred after this date:
=SUMIF(A2:A12, ">"&E1, B2:B112)
The following screenshot shows how to use this formula in practice:
The formula returns a value of 117, which represents the sum of all sales made after 3/1/2023.
We can verify this is correct by manually calculating the sum of all sales after this date:
Sum of Sales after 3/1/2023: 19 + 23 + 28 + 12 + 9 + 14 + 12 = 117
This matches the value calculated by our formula.
Note that if we change the cutoff date in cell E1, our formula will automatically update to show the sum of sales after the new date.
For example, suppose we change the cutoff date to 4/1/2023:
The formula now returns a value of 47, which represents the sum of all sales made after 4/1/2023.
We can verify this is correct by manually calculating the sum of all sales after this date:
Sum of Sales after 4/1/2023: 12 + 9 + 14 + 12 = 47
This matches the value calculated by our formula.
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
How to Count by Month in Excel
How to Count by Year in Excel
How to Calculate Sum by Date in Excel
How to Calculate a Cumulative Sum by Date in Excel
