Link a Data Table Name with a Range

[Henrique Carvalho]

Hi guys!


I have a doubt regarding Excel Data Tables.


I was wondering if it's possible to refer to it using a range. For example:


The formula is:


=COUNTIF(abcp11[Data];">=01/09/10")


I want to make the "abcp11" part variable, using the name "abcp11" in the range B5:


=COUNTIF(B5[Data];">=01/09/10")


The objective is that when I need to recall lots of data tables using this formula above, I lost a lot of time changing the name of various data tables. If I have ranges with the name of the data tables I could do this in no time!


I'm attaching the file if you want to take a deeper look at it:


http://www.megaupload.com/?d=FII6SCH9


Thanks for the attention!


Henrique Carvalho

 

[Hui]

Henrique

You will have to use the Indirect function to help out here

=COUNTIF(INDIRECT(B5&"[Data]"),">=01/09/10")

 

[Henrique Carvalho]

Many thanks Hui!


This will save me a lot of time!