Sum if date is between

An excel formula to sum if date is between

Related Functions

Sponsored Link

 Sum if date is between
=SUMIFS(amount,start_date,">"&A1,end_date,"<"&B1)

To sum values that are between two dates, you can use the SUMIFS function.

In the example shown, cell H5 contains this formula:

 
=SUMIFS(amount,date,">"&H5,date,"<"&H6)

This formula sums the amounts in column D when a date in column C is between a date in H5 and a date in H6. In the example, H5 contains Sept 15, 2015 and H6 contains Oct 15, 2015.

How the formula works

The SUMIFS function supports Excel's logical operators (i.e. "=",">",">=", etc.), and multiple criteria.

To match dates between two values, we need to use two criteria. SUMIFs require that each criteria be entered as a criteria/range pair:

 
">"&H5,date // criteria 1 "<"&H6,date // criteria 2

Note that we need to enclose the logical operators in double quotes ("") then join with cell references using an ampersand (&).

Take care to use greater than or equal to (">=") and less than or equal to ("<=") if you want to include (match) the start or end date as well as the dates in between.

Sponsored Link

0 votes. 0 / 5