Trying to make a Rolling 12 sum formula


Use Case: Have a list of number by a date. Looking to calculate a "Rolling 12", which would be the current month's number, plus the previous 11 months number.

For example, if we are currently in April, the formula needs to sum months May2019 through April2020

I am replacing an Excel sheet, with the following correct rolling 12 formula: =SUMIF(A$3:A15,">="&DATE(YEAR(A15),MONTH(A15)-11,DAY(A15)),B$3:B15)

The data set looks like below. The formula listed above would sum months Feb19 through Jan 20

Thanks in advance.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!