Average Multiple Columns from different tables on different worksheets

[dsrt16]

I have a workbook that is separated into four worksheets (4 quarters)

On quarter 1, I have this formula: =AVERAGE(ServiceTable1[[#Data],[Wd per hour]]). This gives the average word per hour for that quarter.

On quarter 2, I need to have a formula that gives the average of word per hour for both quarter 1 and quarter 2. The table on quarter 2 is called ServiceTable1.2

I can't figure out how to combine ServiceTable1[[#Data],[Wd per hour]] and ServiceTable1.2[[#data],[wd per hour]] to give the combined average of both.

 

[dsrt16]

I couldn't seem to edit the post to add on the other details.

On quarter 3, I need to have a formula that gives the average of quarter 1 word per hour, quarter 2 word per hour, and quarter 3 word per hour.

On quarter 4, I need a formula that gives the average for all the quarters.

Since users will be adding rows to the top of the table, I can't just do =Average('Quarter1:Quarter4'!G3:G9) I need to reference the table column name since they may insert a row before G3, and now those new entries won't be averaged.

 

[dsrt16]

Nevermind. I think I solved it.

=AVERAGE(ServiceTable1[[#Data],[Wd per hour]],ServiceTable1.2[[#Data],[Wd per hour]])

So simple. But for some reason I thought it was not returning the correct data.