Range("A1").formulaArray = "=SUM(IF(DAT2=""WA"",ABS(DAT8),0))"

would be the correction.

--
Regards,
Tom Ogilvy


"Alan Beban" wrote in message
...
There's a typographically erroneous extraneous "{ in the formula.

Alan Beban

Tom Ogilvy wrote:
Range("A1").formulaArray = ""{=SUM(IF(DAT2=""WA"",ABS(DAT8),0))"