How can I sum a range of cells in Excel if the corresponding date is greater than a certain date?

By /

This tutorial will guide you on how to sum a range of cells in Microsoft Excel if the corresponding date is greater than a specified date. By using a simple formula, you will be able to easily calculate the total of cells that meet the given criteria. This feature is particularly useful for organizing and analyzing data that is time-sensitive. Follow the step-by-step instructions to learn how to efficiently sum a range of cells based on a specific date in Excel.

Excel Formula: Sum if Date is Greater Than

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.

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:

x

Related terms:

  1. How to Sum Cells in Excel if Date is Greater Than
  2. How can I use conditional formatting in Google Sheets to highlight cells that are greater than or equal to a certain value?
  3. How do I use Google Sheets to count the number of cells that are greater than a certain number but less than another number?
  4. How can I combine duplicate rows in Excel and sum the corresponding values?
  5. How can I calculate the sum of values in one column based on corresponding values in another column using Excel?
  6. How can I split a date into its corresponding day, month, and year using Excel?
  7. I need to count the number of elements greater than a certain value
  8. How to calculate the average of a range only if greater than zero in Excel?
  9. How do I use Excel to sum values only if they are greater than zero?
  10. How to do a Sum If Greater Than Zero in Excel?