Automatic updated averages

[ssolomon via OfficeKB.com]

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

 

[Guest]

How are the months organized? Is there a separate sheet for each month? If
only one sheet for all the months, how do we know where ( in which row) the
monthly data changes?

 

[ssolomon via OfficeKB.com]

Gary,

The worksheet has a column for the names, then shows the hours available,
then total hours worked. The columns have totals added at the bottom of each
month. Every month is on one sheet (for a particular office/site location).


I plan on doing the same thing with the main group page which shows all the
data broken down by each location (there are totals for each location) and
then there are department and overall business unit totals (with averages).
These are on one sheet but the data (by months) goes from left to right.

Steve

How are the months organized? Is there a separate sheet for each month? If
only one sheet for all the months, how do we know where ( in which row) the
monthly data changes?

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

[quoted text clipped - 29 lines]

Steve