![]() |
HOW DO I UPDATE MONTHLY AVERAGES
We are preparing a spreadsheet that needs to have a running monthly average.
For example, the last quarter of 2008, I need a formula that will average all September, then October, November, etc. Since I do not have any totals for December, I set up a formula for Sept thru Oct, then change it to add Nov, and will add the cells for December. Is there any way to set up a formula to average my months even though my December numbers are not available without having to update the formula each month? Thank you!! |
HOW DO I UPDATE MONTHLY AVERAGES
Yes
But you need to convey more information - describe the layout of your worksheet (what cells are used for data entry) and what formula are you using? "kimmiep" wrote: We are preparing a spreadsheet that needs to have a running monthly average. For example, the last quarter of 2008, I need a formula that will average all September, then October, November, etc. Since I do not have any totals for December, I set up a formula for Sept thru Oct, then change it to add Nov, and will add the cells for December. Is there any way to set up a formula to average my months even though my December numbers are not available without having to update the formula each month? Thank you!! |
All times are GMT +1. The time now is 08:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com