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.

Attached Images

Untitled.png (148.9 KB, 14 views)