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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!