Sum IF function
 

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

I have 3 cells

Let's say A1, A2, and A3

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.

Let's say that cell is C1.

Then in another cell:

=C1+500-A1-A2-A3

or

=C1+500-SUM(A1,A2,A3)

HTH,
Bernie
MS Excel MVP


"patd7260" wrote in message
...

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

Let's assume the value 1500 is in B1, you are entering 3 values in
A1:A3. You want to determine what number you need to have in A4 to
equal 500.

In A4 enter =500-SUM(A1:A3)

If A1:A3 are all zero, A4 will return 500, regardless of the value in
B1. If the values are as follows:


Code:
--------------------

A B
1 25 1500
2 50
3 25

--------------------

A4 will return 400

Is this what you are looking for?


--
swatsp0p


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