Indirect referencing to a different worksheet&Table

Originally Posted by Glenn Kennedy

The syntax that you need is:

=SUM('2010_Sold.xlsx'!January[Current Price])

unfortunately, I need an indirect formula. As I will eventually be including other sheets for a total sumif(indirect())/countif(indirect()) formula. as I need the average of multiple table columns from different sheets.