Please enable JavaScript to view the comments powered by Disqus.


Calculating sumifs with dates as criteria

The SUMIFS formula can be incorporated with logical operators within arguments to check if the date falls in the given range. If dates do fall in given range, 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