I want to create a cell which gives updated monthly averages. Here is the
data that I'm using:

1 Column A Column B
2 Hours Available Hours Worked
3 176 155
4 176 175
5 176 164
6 85 85
7 176 171
8 789 750
This is just a small section for one month. At the end there is a cell that
shows the average for the month with the function =B8/A9 (these cells are
totals of all the numbers above)

The worksheet that I have shows an entire years worth of data that we
forecast. Each month has a total of all hours available and all hours
worked.

In the above set of numbers (lets say this is January 2008), the average
would be 95.06%. The worksheet does have hours available for all the
remaining months, but no hours worked in them.

I want to be able to have on the summary page, a current average, so in Jan
it would show the 95.06, then when February's data is in place, the average
shown would be for up to the month of February (Jan and Feb numbers) and so
on when March comes around.

What function would I use to show this?

Thanks,

Steve

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200711/1