Summing up positive annd Negative number

[zhuangzi]

Hi,
Please advice

How can I sum up (what's the formula) multiple cell (ignoring whether it is positive or negative)?

Example:
+20
-12
+25
-40
Sum = 97

Thank you

 

[VoG]

Try

=SUM(ABS(A1:A4))

which is an array formula that must be confirmed by holding down CTRL and Shift and pressing Enter. If entered correctly Excel will surround the formula in the formula bar with curly braces {}.

 

[sanrv1f]

another option,

=SUMPRODUCT(ABS(A1:A5))

 

[vinod9111]

what's that written in tamil Sankar?