Finding numbers that add to a total

**afish37** · 11-22-2011, 05:07 PM

is there a find function that will search the worksheet to find numbers that add up to a certain number?

**Poisson** · 11-22-2011, 05:15 PM

The only thing I can think of would be to create an =IF formula for it . . .

=IF(A1+B1=10,"YES","NO")

Where A and B are the columns that you would want to add up to equal a certain number and 10 being whatever number you want to find. From there you can identify the "YES" rows and can sort to make it easier to identify.

**afish37** · 11-22-2011, 05:31 PM

I tried it using solver, would that be effective do you think?

**alansidman** · 03-09-2013, 08:19 AM

Here is a solution that will give you the results you are looking for.

http://superuser.com/questions/20492...-a-given-total

**martindwilson** · 03-09-2013, 08:23 AM

http://www.tushar-mehta.com/excel/te...ues/index.html

**RamVador** · 05-16-2013, 11:19 PM

Originally Posted by afish37

is there a find function that will search the worksheet to find numbers that add up to a certain number?

I have tested a lot of different code solutions and the best way is SumMatch from SumMatch com. It is good to compare the trial version against other solutions (php, tushan, etc). SumMatch is far better and faster and there is a new version 1.6. The price is so low that it makes no sense to waste time, that is if you really are into doing work not moking around with rubish slowish code. I would like SumMatch to have a function that can be called from anywhere in the spreadsheet but it looks like that is the next version they are working on.
Anyway, at U$S 30.- there is not much you can buy this days. Here is the screenSpreadsheetWithBalloons.jpg