Thanks, Max, for your suggestion but I think the Offset formula works best
for my needs.
Cheers!

"Max" wrote:

One play to try ..

Sample construct available at:
http://cjoint.com/?bdkIrjLX6m
Melissa_misc.xls

In Sheet1,
Table 1 is in A1:L3, labels in A1:L1 (Jan, Feb .. Dec)
data within A2:L3

In Sheet2,
Table 2 is in A1:L3, labels in A1:L1 (Jan, Feb .. Dec)
data within A2:L3

In Sheet1,
Put in M1: =Sheet2!A1
Copy across to X1, fill down to X3
This will link / place Table 2 right next to Table 1
(makes it simpler to formulate the averages in Sheet3)

Then in Sheet3,
In A1:L1 are the labels: Jan, Feb ... Dec

Put in A2, array-enter (i.e. press CTRL+SHIFT+ENTER):
=AVERAGE(IF(Sheet1!G2:R20,Sheet1!G2:R2))
Copy A2 across and fill down to L3 to populate

Sheet3 will return the required "Table 3"
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Melissa" wrote in message
...
I have values for Jan to Dec for Year 1 in Table 1 and values for Jan to
Dec
for Year 2 in Table 2.

I want to calculate averages in a 3rd table using source data from Tables
1
and 2.

Table 3 also has columns Jan to Dec for Year 2 but the value for each
month
is based on values 6 months after the respective month and 6 months before
the month.

So in Table 3, column 1 under "Jan", I want the average value of Jul to
Dec
in Year 1 and Jan to June in Year 2.

For column 2 "Feb" in Table 3, it would be the average value of Aug to Dec
in Year 1 and Jan to Jul in Year 2.

For column 7 "Jul" in Table 3, it would be the average value of Jan to Dec
in Year 2.