I think that I want to use Sum If, but here is my goal. I have 3 cells
where I will enter numbers that will add up to a number between 0 and
500. Whatever that number is I need to subtract it from 500 and take
that and add it to another cell that is currently valued at 1500.

Example. I enter 0's in the first 3 cells, I need the final cell to
show 2000.

Please help!!
Thanks,
pat


--
patd7260
------------------------------------------------------------------------
patd7260's Profile: http://www.excelforum.com/member.php...o&userid=22625
View this thread: http://www.excelforum.com/showthread...hreadid=385230