I have a small chart that needs to be copied and pasted for each day on which
i take data and want to get averagees out of the progression of days, so the
progression of cells that i am averaging is G24, N24, U24 for the first three
days, but come tomorrow i will need to add AB24 to the average, and so on for
each day that i continue taking data.
Is there a formula that will include in its average the corresponding cell
of each copy of my daily chart? The idea is that today the formula would be
AVG(G24,N24,U24) and I want it to update on tomorrow's copy to behave as
AVG(G24,N24,U24,AB24).

=AVERAGE(IF((MOD(COLUMN(G24:AZ24),7)=0)*(G24:AZ24< ""),G24:AZ24))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

Replace the AZ24 with your last possible cell.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"alexfthe" wrote in message
...
I have a small chart that needs to be copied and pasted for each day on
which
i take data and want to get averagees out of the progression of days, so
the
progression of cells that i am averaging is G24, N24, U24 for the first
three
days, but come tomorrow i will need to add AB24 to the average, and so on
for
each day that i continue taking data.
Is there a formula that will include in its average the corresponding cell
of each copy of my daily chart? The idea is that today the formula would
be
AVG(G24,N24,U24) and I want it to update on tomorrow's copy to behave as
AVG(G24,N24,U24,AB24).