Forum Discussion
Rolling 365 Calculation Glitch
HansVogelaar THANK YOU for your help.
You shall use TODAY(), not TODAY
=SUMIF(date,">="&TODAY()-365,Col)
With TODAY condition returns error, thus not met, thus result is zero.
Thank you for your help. Unfortunately, the SUMIF formula is not returning the correct values. For example, using the suggested formula =SUMIF(Date,">="&TODAY()-365,CoL) that I placed in the row for January 1, 2017 (to have 365 days of data above this row), the SUMIF formula said that I was in Colombia 88 days. However, using a simple SUM formula returned the correct day count of 95 days. Similarly, for my days in USA, the =SUMIF(Date,">="&TODAY()-365,USA) resulted in 315 days vs. 271 using a simple SUM.
Any thoughts?
I misunderstood. Sum within 365 days back from the date in current row, in D2
=SUMIFS($B$2:$B$1000, $A$2:$A$1000, "<=" & $A2, $A$2:$A$10000, ">=" & ($A2-365) )and drag it down.
Same for the next column.
- Thank you Sergei for your help. I greatly appreciate it.