SUMIFS(...)
How to calculate sumifs 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 checks for the date if they fall in the given date range, as MS Excel assumes date to be numbers, we can make use of logical operators to compare values. The resulting values are summed to get the final answer.