Absolute Value of Range

[jstevens]

Is there a way to calculate the absolute value of a range of cells through a formula? The range contains positive and negative.

untitled.png

Thanks,
John

[HansV]

If you want to sum the absolute values of the cells in A2:C5, use the following array formula (confirm with Ctrl+Shift+Enter):

=SUM(ABS(A2:C5))

[jstevens]

Hans,

You're amazing.

I was so close with =ABS(SUM(A2:C5))

Regards,
John

[HansV]

Your formula will first sum the original numbers (positive and negative), then take the absolute value of the sum.
But you want to calculate the sum of the absolute values, hence SUM(ABS(...))