Cobination of numbers from a List to add to specific number

[hanz753]

Hello,

I have a list of number, and from the list of numbers(Column B, 500 rows) I need to be able to see selected number to add to aspecific number.

E.g
4
33
34
3
From the list I need to select number that add to 37. Therethe operation would select 4 and 33.

I have used solver, but for some reason I keep getting anerror message “ Solver32.dll”

Is there an alternative?
Hanz

 

[Joe4]

If you are getting a "Solver32.dll" error, it sounds like you do not have the proper Add-In (that contains Solver) loaded or enabled.
See: https://www.solver.com/excel-solver-how-load-or-start-solver