SUMIFS(...)
How to find sum with sumif range condition as dates
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
For calculating against range of dates, 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.