Using Table Names in Formula

[cosmica67]

Hi, All.

I have attached a spreadsheet with multiple tabs.

The data in each Year tab is arranged in tables but I cannot work out how to substitute the table name for the range currently in the formula.

The Data Collation tab (Cells Q13:R18) is where the formula calculates the average from data stored in different Year tabs based on a range of years.

What I would like to happen is when I add to the data tables in each Year tab, the formula automatically updates with the new table range.

Many thanks for looking.

[Fluff13]

How about

Please Login or Register  to view this content.

[cosmica67]

Fluff13,

That formula works perfectly!!

Many thanks.

[Fluff13]

You're welcome & thanks for the feedback.