Why do you say the answer is wrong? If you want to add the first 2 values
and subtract the third, then that's the answer you've got.

If at the moment your formula is effectively =A+B-C, what do you want the
formula to be? If you want it to be =A+B+C, then you are adding the 3
values. Is that what you want?
--
David Biddulph

"Carol@Bell" wrote in message
...
I'm trying to create a summary sheet from 3 tabs of data. Want to add the
first two values and subtract the third. It's working, but sometimes my
first value is a negative value and when i subtract the 3rd positive value
my
result is wrong. I.e., first value is -300, second value is null (no
affect)
and third value is 19, (-300+0-19)which results i a negative -319 when
what i
want is -281. Is there a way to handle this so i don't have to edit each
cell individually? Thanks in advance.