Hello

im just having an issue as im not embedding the quotations properly for the formula to function...

here is my original formula:
=SUMPRODUCT(--(LEFT('[YTD_District (2011).xls]Toronto'!$A$2:$A$59,2)=$C$4),('[YTD_District (2011).xls]Toronto'!$G$2:$G$59))


i would like to modify is, so instead of typing in seperately the city name, it references the cell $A13 etc......but im messing up on my placement of ""......
=SUMPRODUCT(--(LEFT("'[YTD_District (2011).xls]"&A13&"'!$A$2:$A$59,2)=$C$4),("'[YTD_District (2011).xls]"&A13&"''!$G$2:$G$59))

thx you very much!