The start date is provided in cell E5, and the end date is provided in cell F5.

A good way to solve this problem is with theSUMIFS function.

Note: for SUMIFS to work correctly, the worksheet must usevalid Excel dates.

Excel formula: Sum if date is greater than

We do this by entering two arguments:criteria_range1andcriteria1.

We do this in the same way, by adding two more arguments:criteria_range2andcriteria2.

That said, there may be times when you oughta hardcode dates directly into a formula.

Excel formula: Sum if not blank

How to use the SUMIFS function

Excel formula: Sum if cells are equal to

Excel formula: Sum if cells are not equal to

Excel formula: Sum if x or y

Excel formula: Sum if cells contain specific text

Excel SUMIFS function

Excel DATE function

Article image