formula help:adding without regard to +/-

[Viviank]

How do I tell excel to add a column of numbers without regard to +/- sign. I
want to know the gross total of all adjustments, not the net. Here's the
scenario. A house sells for $200,000, we make adjustments for differences,
say -$1,000 here, +3,000 there, I want excel to tell me that I've made $4000
in adjustments - not +2000. Thanks for your help.

Vivian

 

[Peo Sjoblom]

=SUM(ABS(E1:E10))

entered with ctrl + shift & enter

or

=SUMPRODUCT(ABS(E1:E10))

entered normally


--


Regards,


Peo Sjoblom

 

[ShaneDevenshire]

Hi,

Suppose your numbers are in A1:A10 then the formula would be:

=SUMPRODUCT(ABS(A1:A10))

--
Cheers,
Shane Devenshire
Microsoft Excel MVP
Join http://setiathome.berkeley.edu/ and download a free screensaver to help
search for life beyond earth.

 

[Viviank]

Worked like a charm. Thanks, you guys rock.

vk

Hi,

Suppose your numbers are in A1:A10 then the formula would be:

=SUMPRODUCT(ABS(A1:A10))

--
Cheers,
Shane Devenshire
Microsoft Excel MVP
Join http://setiathome.berkeley.edu/ and download a free screensaver to help
search for life beyond earth.