View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default 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!!