SUMIFS(...)
Calculating sumifs with date as a condition.
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 SUMIFS formula can take logical operators within arguments to verify if the date falls in the given date range, as it does, the number against the date is added to the final sum.