formula help:adding without regard to +/-
 

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

formula help:adding without regard to +/-
 

=SUM(ABS(E1:E10))

entered with ctrl + shift & enter

or

=SUMPRODUCT(ABS(E1:E10))

entered normally


--


Regards,


Peo Sjoblom


"Viviank" wrote in message
...
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

formula help:adding without regard to +/-
 

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" wrote:

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

formula help:adding without regard to +/-
 

Worked like a charm. Thanks, you guys rock.

vk

"ShaneDevenshire" wrote:

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" wrote:

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