C3 = 10

D3 = 15

E3 = -30

F3 = 15

G3 = -10

The formula =Sum(C3:G3) results in zero

The formula =SUM(ABS(C3:G3)) results in 80

I would expect the result of the following formula to be "GOOD" - but it results in "BAD" and I cannot figure out why.

=IF(AND(SUM(C3:G3)=0,SUM(ABS(C3:G3)<>0)),"GOOD","BAD")

Both conditions are true - the sum of C3:G3 is zero, and the sum of the absolute values of those cells does NOT equal zero.

Help please!