Usind dynamic references in a table name

[AaronDP]

Hi, Hopefully you can help?

I am trying to create a dynamic reference in a table name using..

=SUMIF((CONCATENATE("rev_"&E2))[ITEM],"11*",Alacer!F:F)

E2 = wk12
Table name = rev_wk12

I am trying to reference the table name by concatenating the name and then addressing column [ITEM]

And ideas what I am doing wrong?

Excel 2010 & windows 7

Thanks

Aaron

 

[Derek Brown]

Try:
=SUMIF(INDIRECT("rev_"&E2&"[ITEM]"),"11*",Alacer!F:F)