Sum Function over Today +/- 60 Days
Hello,
I am trying to get a formula to SUM numbers over multiple rows over a specific date range (Today + and - 60 days, totaling 120 days). The sum function is working fine, but for some reason I cannot get it to only take the specific date range into account. Excel is not indicating any error.
=SUMIF('CY1 (2)'!D7:NE22,"<=" &TODAY()-60)+SUMIF('CY1 (2)'!D7:NE22,"=" &TODAY()+60)
Looking at the picture below, it should only show 3 summing the 120 days in question, but it is adding the one I have placed in January and the one I placed in December, totaling 5.
|