Adding up Absolute numbers

[nycnights]

I'm working on a spreadsheet in which one column has both negative and positive number. Below the column I would like a sum of the absolute values of those figures I tried this formula but it didn't work. =sum(abs(A1:a5)) I also tried =sum(abs(a1):abs(a5)). Any ideas.. Please help.

-Danny

 

[Aladin Akyurek]

=SUMPRODUCT((ABS(A1:A5)))

would do.

 

[nycnights]

Thanks Aladdin. It works perfectly.

-Danny

 

[IML]

I'm glad you got a workable solution. Another way to do this without an array type solution would be
=SUMIF(A1:A5,">0")-SUMIF(A1:A5,"<0")

I'd only go with this if you are using the formula often in a big sheet and notice performance issues.

Good luck