SUMIFS(...)
How to sumif with date range
Used Functions
Category: Math and trigonometry
Adds the cells in a range that meet multiple criteria
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Practice SUMIFS Formula at Sheetzoom
SUMIFS formula at Microsoft help
0
The formula uses logical operators within SUMIFS formula to check if the date falls in the given range. Provided it does, the number against the date is added to the final sum.