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