I have made a spreadsheet to keep attendance based on percentages. I want to
be able to insert a formula in the last column to calculate a running average
total. Example, at the end of March they have 100%, but in April they only
have 50% attendance, so the yearly would be 87.5%.

It can't be that difficult, but I can't figure out how to do it. Plus, I
don't want to change the formula each month.

THANKS
--
Tammy

Maybe something like this...........

=SUM(A1:L1)/COUNT(A1:L1)

hth
Vaya con Dios,
Chuck, CABGx3



"Tammy" wrote:

I have made a spreadsheet to keep attendance based on percentages. I want to
be able to insert a formula in the last column to calculate a running average
total. Example, at the end of March they have 100%, but in April they only
have 50% attendance, so the yearly would be 87.5%.

It can't be that difficult, but I can't figure out how to do it. Plus, I
don't want to change the formula each month.

THANKS
--
Tammy

I tried it and it still doesn't work.

Here is a piece of the spsheet.

Jan-06 Total Feb-06 Total Mar-06 Total
1/5 1/19 2/2 2/16 3/2 3/16

w w 100% w w 100% w w The w indicates they worked. So the yearly total
needs to show a up to date total in percent.

--
Tammy


"CLR" wrote:

Maybe something like this...........

=SUM(A1:L1)/COUNT(A1:L1)

hth
Vaya con Dios,
Chuck, CABGx3



"Tammy" wrote:

I have made a spreadsheet to keep attendance based on percentages. I want to
be able to insert a formula in the last column to calculate a running average
total. Example, at the end of March they have 100%, but in April they only
have 50% attendance, so the yearly would be 87.5%.

It can't be that difficult, but I can't figure out how to do it. Plus, I
don't want to change the formula each month.

THANKS
--
Tammy

"Tammy" wrote in message
...
I have made a spreadsheet to keep attendance based on percentages. I want
to
be able to insert a formula in the last column to calculate a running
average
total. Example, at the end of March they have 100%, but in April they
only
have 50% attendance, so the yearly would be 87.5%.

It can't be that difficult, but I can't figure out how to do it. Plus, I
don't want to change the formula each month.

If your monthly attendance figures are in column B, starting in B1, your
running average formula can be =AVERAGE(B$1:B1) in the January row, which
when you copy it down the column will be =AVERAGE(B$1:B4) by the time you
get to April, for example.
--
David Biddulph