The Average of an Average is the average of all the data. In other words you
are working too hard.

If you want the average of the average of the rows on sheet2 it is simply
the AVERAGE(Sheet2!A1:AL50)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"THE BOB" wrote:

I have a spreadsheet with 2 sheets. I'm using a formula on page one to
average each row of page two (six columns). Then I have to average the
averages within the same formula. The number of rows of data on page two is
unlimited and I can't figure out how to average each row without loading a
formula for each row. I there a way to do this automatically? Here is a
sample of the formula I'm using for the first row which is row 12:

=AVERAGE(AVERAGE(SHEET2!AG$12,AL$12))