How to sum values between two dates in Excel?

Fortunately, there is a formula that can sum up the values between two dates range in Excel.

Select a blank cell and type into below formula, and press Enter button. And now you will get the calculating result. See screenshot:

=SUMIFS(B2:B8,A2:A8,">="&E2,A2:A8,"<="&E3)

Formula is too complicated to remember? Save the formula as an Auto Text entry for reusing with only one click in future! Read more…     Free trial

Easily sum data in every fiscal year, every half year, or every week in Excel

The PivotTable Special Time Grouping feature, provided by Kutools for Excel, is able to add a helper column to calculate the fiscal year, half year, week number, or day of week based on the specified date column, and let you easily count, sum, or average columns based on the calculated results in a new Pivot Table.

If you need to sum values between two dates, and the date range changes frequently, you can add filter for the certain range, and then use the SUBTOTAL function to sum between the specified date range in Excel.

1. Select a blank cell, enter below formula, and press the Enter key.

=SUBTOTAL(109,D3:D22)

Note: In above formula, 109 means sum filtered values, D3:D22 indicates the value list you will sum up.

2. Select the range title, and add filter by clicking Data > Filter.

3. Click the filter icon in the Date column header, and select Date Filters > Between. In the Custom AutoFilter dialog, type the start date and end date as you need, and click the OK button. The total value will change automatically based on filtered values.