T
THE BOB
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))
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))