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