Sum IF function

[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

[swatsp0p]

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:

Please Login or Register  to view this content.

A4 will return 400

Is this what you are looking for?

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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.

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>