Sum if date is between
Generic formula
=SUMIFS(amount,start_date,">"&A1,end_date,"<"&B1)
Related formulas
Sum if date is greater than
Sum if begins with
Sum if not blank
Sum if cells are equal to
Sum if cells are not equal to
Sum if equal to either x or y
Sum if cells contain specific text
Explanation
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 ("<=")></=")>