I have a problem with the month# desired entered in cell C1. Dates are in Cells C3-Z3 (i.e. Jan-2016 to Dec 2017). Product1 name is in cell B5. Product2 name is in cell B6. Data1 amounts are in C5 to Z5. Data2 amounts are in C6 to Z6. What formula would I need to add in cell AB5? Given the below specs: Col AB5 needs to calculate the rolling 12 months based on cell C1. So if C1=3 (i.e. Mar 2017), it should calculate amounts in F5 through Q5 (i.e. Apr 2016 through Mar 2017). If C1=4 (i.e. Apr 2017), it should dynamically calculate amounts in G5 through R5 (i.e. May 2016 through Apr 2017). Any help will be greatly appreciated. Thank you!
Solved by D. Y. in 21 mins