formula help:adding without regard to +/-

  • Thread starter Thread starter Viviank
  • Start date Start date
V

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
 
=SUM(ABS(E1:E10))

entered with ctrl + shift & enter

or

=SUMPRODUCT(ABS(E1:E10))

entered normally


--


Regards,


Peo Sjoblom
 
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.
 
Worked like a charm. Thanks, you guys rock.

vk

ShaneDevenshire said:
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.
Click to expand...
 
Back
Top