Absolute value

[Guest]

Hello,

I want to find the sum of a column, where the sum of the column adds the
absolute value of each cell. For example:

F1 = 10
F2 = -10
F3 = -5

So when I want to put in the equation in say F4, the answer would be 25 and
not -5

How do I do this for a whole column?

 

[Rob van Gelder]

=SUMPRODUCT(SIGN(F1:F3), F1:F3)

 

[Bob Phillips]

=SUM(ABS(A1:A1000))

which is an array formula, so commit with Ctrl-Shift-Enter

 

[Guest]

Hi
and just another alternative combining Rob's and Bob's solution
=SUMPRODUCT(ABS(A1:A10))

which does NOT need to be array entered