Trying To Dynamically Refrence Table

[Keenan]

Hello,

Can someone please assist me in dynamically referencing a table?

If I have a table called Table04.01.17 can I tell excel to look for Table(A3) with A3 with 04.01.17? So the output would be Table04.01.17.

So right now I can do =COUNTA(Table03.01.17[COST]) but rather than updating it on each cell I would just like it to reference the data cells I am using for the other formulas.

[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD][/TD]
[TD]Amount[/TD]
[TD]Amount (formula)[/TD]
[TD]Amount (ideal formula)[/TD]
[/TR]
[TR]
[TD]03.01.2017[/TD]
[TD]16[/TD]
[TD]=COUNTA(GGA03.01.17[COST])[/TD]
[TD]=COUNTA(GGA(A2)[COST])[/TD]
[/TR]
[TR]
[TD]04.01.2017[/TD]
[TD]5[/TD]
[TD]=COUNTA(GGA04.01.17[COST])[/TD]
[TD]=COUNTA(GGA(A3)[COST])[/TD]
[/TR]
[TR]
[TD]05.01.2017[/TD]
[TD]22[/TD]
[TD]=COUNTA(GGA05.01.17[COST])[/TD]
[TD]=COUNTA(GGA(A4)[COST])[/TD]
[/TR]
[TR]
[TD]06.01.2017[/TD]
[TD]15[/TD]
[TD]=COUNTA(GGA06.01.17[COST])[/TD]
[TD]=COUNTA(GGA(A5)[COST])[/TD]
[/TR]
</tbody>[/TABLE]

Many thanks,
Keenan

 

[wideboydixon]

In C2 try this:

=COUNTA(INDIRECT("GGA"&$A2&"[COST]"))

WBD