How can I add numbers but ignore the minus signs?

[Invalid]

How can I add numbers but ignore the minus signs? In the following, the
answer I'm after is 17

A1 -10
A2 5
A3 -2

 

[Gord Dibben]

=SUMPRODUCT(ABS(A1:A3))


Gord Dibben MS Excel MVP

 

[Invalid]

Gord Dibben <gorddibbATshawDOTca> wrote in

Thank you Gord.

-----