The formula in cell C15 uses two dates two to filter and then sum values in column C, the SUMIFS function is designed to use multiple conditions.
The first condition filters dates less than or equal to the end date in cell C14.
The second condition filters dates larger than or equal to the start date in cell C13.
The ampersand character lets you concatenate the logical operators to the date value. The following picture shows the date values that match both conditions.
The SUMIFS function has the following arguments:
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Sum by date range
The SUMIFS was introduced in Excel 2007, the following formula works with Excel versions earlier than 2007.
Download excel *.xlsx
Sum between two dates.xlsx