I am trying to create a formula that will allow me to add both negative and
postive numbers in the same column. It appears that when I use the SUM
function, EXCEL is doing the addition first and then subtracting any negative
from there producing the wrong outcome. Ex: a1 to a10 all have 100 in it.
total would be 1000. When I introduce a -100 anywhere witin a1 to a10, I
recieve 800 instead of 900. Any help would be greatly appreciated. Thank you

Hi,

The answer should be 800 itself. 9*100=900. Now 900-100=800

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Coach O" <Coach wrote in message
...
I am trying to create a formula that will allow me to add both negative
and
postive numbers in the same column. It appears that when I use the SUM
function, EXCEL is doing the addition first and then subtracting any
negative
from there producing the wrong outcome. Ex: a1 to a10 all have 100 in it.
total would be 1000. When I introduce a -100 anywhere witin a1 to a10, I
recieve 800 instead of 900. Any help would be greatly appreciated. Thank
you

Excel does not 'remember' you once had ten values of 100; all it sees are
nine values or 100 and one of -100 giving 800
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Coach O" <Coach wrote in message
...
I am trying to create a formula that will allow me to add both negative and
postive numbers in the same column. It appears that when I use the SUM
function, EXCEL is doing the addition first and then subtracting any
negative
from there producing the wrong outcome. Ex: a1 to a10 all have 100 in it.
total would be 1000. When I introduce a -100 anywhere witin a1 to a10, I
recieve 800 instead of 900. Any help would be greatly appreciated. Thank
you

Thank you for your help

"Bernard Liengme" wrote:

Excel does not 'remember' you once had ten values of 100; all it sees are
nine values or 100 and one of -100 giving 800
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Coach O" <Coach wrote in message
...
I am trying to create a formula that will allow me to add both negative and
postive numbers in the same column. It appears that when I use the SUM
function, EXCEL is doing the addition first and then subtracting any
negative
from there producing the wrong outcome. Ex: a1 to a10 all have 100 in it.
total would be 1000. When I introduce a -100 anywhere witin a1 to a10, I
recieve 800 instead of 900. Any help would be greatly appreciated. Thank
you