sum of absolute values

[pete_22]

is there a way to sum the absolute values of a column of numbers in a single formula? for example, it would refer to three cells containing 4,5,-6 and return 15.

i can think of some roundabout ways to do it, like:

=-sumif(range,"<0",range)+sumif(range,">0",range")

but wondered if someone here knew a more direct method, something analagous to =sumif(abs(range)) although that obviously isn't quite it.

thanks,
peter

[pete_22]

found it in another post

[Trebor76]

Hi there,

Entered as an array, =SUM(ABS(RANGE)) will work. Have a look at
http://exceltips.vitalnews.com/Pages...te_Values.html for more details.

HTH

Robert