Duggiefrshmc
New Member
- Joined
- Apr 10, 2002
- Messages
- 1
How do I format a cell to average the last 12 entries. So that I can have a monthly average for the the last 12 months. I enter new data in the next cell for the previous month. At this time I have to change the formula every month. Is there a way to have the cell range change automaticly when I enter a new month?