Please enable JavaScript to view the comments powered by Disqus.


Calculating sumifs with date as a condition. 

The 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


SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Lets chat on this