adding positive and negative numbers

C

Coach O

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting positive amts from negative and positive from positive 3
Matching Negative and Positive Values 20
How to round negative and positive numbers 6
How do I get a index% of two numbers when they are negative or pos 1
making a # value positive or negative based on contents of another 2
finding maximum, minimum in a range consists both Positive and Negative numbers 2
I have a column of numbers, some negative, some positive 3
column of negative numbers into positive numbers 2

Top