Please enable JavaScript to view the comments powered by Disqus.


SUMIFS(...(...C4:C15),(...B4:B15),(...">="&B17),(...B4:B15),(..."<="&B18))

How to sumif with date range

The formula uses logical operators within SUMIFS formula to check if the date falls in the given range. Provided it does, the number against the date is added to the final sum.


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], ...)

Lets chat on this