Excel Solver - find 2 numbers that Sum to a value

In this video learn how to use Solver to find 2 numbers that total to a Value in a given range of numbers. this might be useful in some bookkeeping or accounting problems.

[Virginiagirl]

You did an excellent job of condensing and explaining these topics in this and the previous Excel video. Thank you!

[swee]

Hi love it . For simplicity after showing 1s and 0s put the table in an Excel table that way when u filter for 1s table already has totals justifying the combination

[haroonjan]

Mr amir parmar you are a good teacher thank you very much for the tutorial viceos

[giorgichelishvili]

Thank you very much, this video saved my day! I did not use solver function before but surely I will in the future.

[yuyunsriwahyuningsih]

I found you... Thank you very much.

But, I have a problem. I can't add integer like in formulas.

[samkab]

What to do if we have products like product A?
For example i want a constraint for product A?

[zainabghareeb]

What if I want highlight the original cells that equals to the target without having an extra column ?

[beckiwozniak]

How do I get an exact match? I have three numbers to solve for for the same group of numbers

[hobirumahan]

What about with many target ini a cell

[zeyadsherif]

I need to find the sum equel Zero with solver for +- amounts

[LumiLunar]

Thanks for the video. Idk if you'll see this because it's been years since you've created this video.

I recreated this on excel. The downside is that this solver model doesn't work with decimals. If my set of numbers are decimals then column B will also appear as decimals. I wonder if there is a way around this.

[raulfff]

how would you do this exact example but instead of sum its subtraction? and with more than 200 variables!!!!

[RebeccaDown-di]

For some reason my integer constraint didn't seem to work - does this mean it can't be solved?

[fffass]

What if you want to find a combination of numbers that sum to zero? is that possible with Excel solver because I can't figure out how to change your excel solver set up to accomplish this

[RichArd-eeqj]

Great video Amir. For column A, do the values have to be in numerical order? Or can they be a random series of numbers?

[riteshpanchal]

This function does not work for more than 200 variable. Please advise alternative solution.

[nikunjtilavat]

Hello parmar sir your explaination is perfact
I just want explaination on page brake in ms word it quit difficult to understand

[albinodipasquale]

hi i have an error that says "objective cells content must be a formula" what am i doing wrong?

[techblokeshsaini]

ms office 2016 kese download and install kare