SUMIFS(...)
Calculating sumifs with dates as criteria
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 be incorporated with logical operators within arguments to check if the date falls in the given range. If dates do fall in given range, the number against the date is added to the final sum.