A good way to solve this problem is with theSUMIFS function.
Note: for SUMIFS to work correctly, the worksheet must usevalid Excel dates.
Each condition requires a separaterangeandcriteria, and operators need to be enclosed in double quotes ("").
This is a quirk of theSUMIFS function.
Notice we arenotincluding the start date in the result.
The syntax is similar, but the order of theargumentsis different.
This is a nice solution, because it makes the start date easy to change.
However, there may be times when you want to hardcode a date into a formula.
SUMIF Function
The Excel SUMIF function returns the sum of cells that meet a single condition.
Criteria can be applied to dates, numbers, and text.
Related videos
How to use the SUMIFS function
How to use the SUMIF function
