FormulaArray Not working

[Daywalker]

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

Please Login or Register  to view this content.

[shg]

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

[shg]

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

[romperstomper]

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)

[shg]

IMO as well.

[Daywalker]

That did the trick, thanks folks

[Paul]

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

Please Login or Register  to view this content.

No?