FormulaArray Not working

I have a formulaarray that I cannot work out why it's not working, can anyone see anything I'm missing ?

Sheets("Targets Achieved").Select
    Range("D9").FormulaArray = _
    "=SUMIF(Monday!J1:J1718,"EQS",Monday!L1:L1718)+SUMIF(Tuesday!J1:J1754,"EQS",Tuesday!L1:L1754)+SUMIF(Wednesday!J1:J1763,"EQS",Wednesday!L1:L1763)+SUMIF(Thursday!J1:J1772,"EQS",Thursday!L1:L1772)+SUMIF(Friday!J1:J1769,"EQS",Friday!L1:L1769)+SUMIF(Saturday!J1:J1805,"EQS",Saturday!L1:L1805)+SUMIF(Monday!J1:J1718,"EQJ",Monday!L1:L1718)+SUMIF(Tuesday!J1:J1754,"EQJ",Tuesday!L1:L1754)+SUMIF(Wednesday!J1:J1763,"EQJ",Wednesday!L1:L1763)+SUMIF(Thursday!J1:J1772,"EQJ",Thursday!L1:L1772)+SUMIF(Friday!J1:J1769,"EQJ",Friday!L1:L1769)+SUMIF(Saturday!J1:J1805,"EQJ",Saturday!L1:L1805)+SUMIF(Monday!J1:J1719,"EQF",Monday!L1:L1719)+SUMIF(Tuesday!J1:J1755,"EQF",Tuesday!L1:L1755)+SUMIF(Wednesday!J1:J1764,"EQF",Wednesday!L1:L1764)+SUMIF(Thursday!J1:J1773,"EQF",Thursday!L1:L1773)+SUMIF(Friday!J1:J1770,"EQF",Friday!L1:L1770)+SUMIF(Saturday!J1:J1806,"EQF",Saturday!L1:L1806)"