Averages

[Guest]

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).

 

[Bob Phillips]

=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)