"Myrna Larson" wrote...
In fact you don't need to "roll your own" average. this formula also works:

=AVERAGE(Sheet1!A1:A500,Sheet2!A1:A500)
....

And if Sheet1 and Sheet2 were adjacent,

=AVERAGE(Sheet1:Sheet2!A1:A500)

would also work.