This post will guide you how to sum values in column where a date column meets two date criteria with a formula in Excel. How do I sum values between two dates in a range in Excel.

Assuming that you have two list of data in range A1:B5, and one column contain Dates and another column contain values. And you want to sum values in column B between two specified dates (2018/8/20-2019/8/20) in column A. How to achieve it. Let’s see the following detailed steps.

Sum Values between Two Dates with Formula

If you want to quickly sum values between two dates in Excel, you can create a formula based on the SUMIF function. Like this:

=SUMIFS(B1:B5,A1:A5,">="&D1,A1:A5,"<="&D2)

Type this formula into a blank cell, and then press Enter key in your keyboard.

You will see that the summed value has been generated.

Related Functions

• Excel SUMIF Function
  The Excel SUMIF function sum the numbers in the range of cells that meet a single criteria that you specify. The syntax of the SUMIF function is as below:=SUMIF (range, criteria, [sum_range])…