Sumproduct & Indirect returning 0 or incorrect

[moose79]

Hi all,
Hoping someone can help me with this formula:

{=SUMPRODUCT(INDIRECT("'"&"2010_Sold.xlsx"&"'!"&{"January","February","March"}&"["&"Current Price"&"]"))}

Which is returning 0

Or, =SUMPRODUCT(SUM(INDIRECT("'"&"2010_Sold.xlsx"&"'!"&{"January","February","March"}&"["&"Current Price"&"]")))

Returns the incorrect answer

I know =SUM(INDIRECT("'"&"2010_Sold.xlsx"&"'!January"&"["&"Current Price"&"]")) gives me the right answer for just the January table.

January,February,March are tables in the 2010_sold workbook. Current Price is a column in those tables.

Reason I'm doing it like this is because I'd like to divide it by a similar function of countif to get the average across different tables.

Im aware I can write a long formula, with the sums of all months and then a sum count of each table. Its just very long. Hoping to do it this way.