Please enable JavaScript to view the comments powered by Disqus.


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

How to find sum with sumif range condition as dates

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.


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