SimonHughes
Active Member
- Joined
- Sep 16, 2009
- Messages
- 452
- 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