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)"

Please edit your post to have CODE tags, not PHP tags.

Thanks.

Two things -- first, you have to double the quotes inside quoted strings, so "EQS" changes to ""EQS""

Second, you can't enter an array formula longer than 255 characters from VBA. You can work around this in various ways. For example, define

MonEQS refers to: =SUMIF(Monday!J1:J1718, "EQS", Monday!L1:L1718)

.. and other sections similarly, and then the formula can be

=MonEQS + TueEQS + ... + SatEQS + MonEQF + ... + SatEQF

It would also, IMO, be a lot easier to put a summary table on each day's sheet and refer directly to the relevant cells there (or consolidate to one master sheet for analysis)

IMO as well.

Might I ask why you're using "FormulaArray" to begin with? SUMIF functions are not array formulas, even if you add 21 of them together.

You should be able to use just

Range("D9").Formula = ...

No?