SimonHughes
Active Member
 Joined
 Sep 16, 2009
 Messages
 428
 Office Version

 365
 Platform

 Windows
Hello, I have a column of monthly sales in the range D2:D90 (next month it will be D2:D91 and so on). I want to sum and average the last six, 12, 18 months ect but cannot work out the formula. The first formula will need to sum cells D85:D90. Any help would be appreciated, many thanks
I am working on Excel 2010
I am working on Excel 2010