Sum IF function

P

patd7260

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
 
B

Bernie Deitrick

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.
Click to expand...

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
 
S

swatsp0p

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

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

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


Code
-------------------

A B
1 25 1500
2 50
3 25
 
Top