I have searched and searched all day for this answer and cannot find it.

I simply want the following:

Column A Column B = Column C

-$5 $6 = $1

$8 $2 = $6

-$2 $5 = $3

$5 -$5 = $0

See my pattern? ABS won't work because for example you end up with 11 on the first one. I don't want percent difference either. A1-B1=C1 won't work because sometimes A is positive and sometimes B is positive. Nor the reverse of A1+B1=C1 it will work only when the order of numbers is correct. I am trying to avoid doing each row individually.

This seems so simple, but is killing me. Basically column A is estimated and column B is actual and I want to see the difference on these projects.

Thank you Thank you Thank you for any help! Again I have searched and searched and either don't know the correct terms or it is so simple people haven't asked it or...??? I see close topics, but nothing quite like this.

I searched "sum negative positive", "find difference", etc...

I hope I am not wasting anyone's time, but I really can't figure this out.

I simply want the following:

Column A Column B = Column C

-$5 $6 = $1

$8 $2 = $6

-$2 $5 = $3

$5 -$5 = $0

See my pattern? ABS won't work because for example you end up with 11 on the first one. I don't want percent difference either. A1-B1=C1 won't work because sometimes A is positive and sometimes B is positive. Nor the reverse of A1+B1=C1 it will work only when the order of numbers is correct. I am trying to avoid doing each row individually.

This seems so simple, but is killing me. Basically column A is estimated and column B is actual and I want to see the difference on these projects.

Thank you Thank you Thank you for any help! Again I have searched and searched and either don't know the correct terms or it is so simple people haven't asked it or...??? I see close topics, but nothing quite like this.

I searched "sum negative positive", "find difference", etc...

I hope I am not wasting anyone's time, but I really can't figure this out.

Last edited: