Sum of a range of absolute numbers
This worked great. Thanks.
"Thomas [PBD]" wrote:
SteveG,
Please use:
=SUMPRODUCT(ABS(A1:D1))
--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.
"SteveG" wrote:
I need to sum a row of numbers that are both positive and negative. What I
would like to do is sum them as absolute values.
Example:
A1=2, B1=-3, C1=-1, D1=5
Sum(abs(A1:D1)) should equal 11 (2+3+1+5) not 3 (2-3-1+5).
This doesn't work. Does anyone have a suggestion on how to do this.
|