Adding Positive and Negatives

This should be simple, but I'm struggling.

I have two columns of numbers that I am trying to find the difference between.

If A1 is negative and B1 is positive the formula A1-B1 will add the two columns together. The numbers switch signs as you go down the column. I want one formula that will return the difference regardless of the sign. I don't want the absolute value of the difference....but rather the difference.

Any ideas?

Hi,

How about

Formula:

Please Login or Register  to view this content.

See the attached.

Thanks, but that returns the same thing I'm getting with my mile long formula. This is accounting, so I need my debits to be debits and my credits to be credits. I attached a sample of my data. If anyone can figure this out, I'd be most grateful.

Perhaps,

this is what you mean then

Formula:

Please Login or Register  to view this content.

No, it's more complex than that. My formula works, right up until column A2 has a 0. B2 is a Debit, so it should be using the first argument in the formula, not the last. The problem is, the first argument says if A2 is less than 0 (a negative number), then sum. How do I get it to say less than or equal to zero.

=IF(AND(A3<0,B3>0),SUM(A3:B3),IF(AND(A3>0,B3<0),SUM(A3:B3),A3-B3))

add equal sign after ">"

Your formula worked Wakeup! Thank you so very much. Though I can't say it out loud in long form....which I like to do because it seems to make sense to me that way. Oh well, at least it works...and that's what's important at this point.

Thank you again!