"Dave Peterson" wrote...
....
But my question is when does this become faster?

=abs(sumproduct(-(),-(),-(),-())
....

Compared to =SUMPRODUCT(--(),--(),--(),--())? I don't know, but I'd guess
it'd take quite a number of double unary minuses to equal one function call.