Combination of numbers that give a single total

I am aware this has been discussed overtime and many solutions offered. However, I need something simple that suits my purpose.

I have a column A with numbers. I have a total in R1C2 and I want the numbers in column A that sum this total to be placed in column C. I expect only one unique solution from the nature of my data which is not too large though I would have iterate through a couple of small data sets.

I have attempted this solution with solver but I ran into a deadend. Apparenty solver does not update for relations 4,5,6 hence when you constrain with integer or binary it returns decimals. I did check the ignore integer option but still had same results. There seems to be no solution to this online and I have contacted the solver folks and I can't even wait for their response because I have limited time.

I am hard pressed for time and need this ASAP.

Can someone help. I would provide more info if need be.

I forgot to add that I would delete the rows that were identified so that it reduces the number of matching combinations for other trades.

Hi all,

I got the solution to this problem which is very simple really.

Instead of Sub solver_binary_constraint()
'
' solver_binary_constraint Macro
'

'
SolverReset
SolverOptions MaxTime:=0, Iterations:=0, Precision:=0.000001, Convergence:= _
0.0001, StepThru:=False, Scaling:=False, AssumeNonNeg:=True, Derivatives:=1
SolverOptions PopulationSize:=100, RandomSeed:=0, MutationRate:=0.075, Multistart _
:=False, RequireBounds:=True, MaxSubproblems:=0, MaxIntegerSols:=0, _
IntTolerance:=1, SolveWithout:=False, MaxTimeNoImp:=30

SolverAdd CellRef:="$E$11:$E$17", Relation:=5, FormulaText:="binary"
SolverOk SetCell:="$E$18", MaxMinVal:=3, ValueOf:=1226873, ByChange:= _
"$E$11:$E$17", Engine:=2, EngineDesc:="Simplex LP"

Solversolve

End Sub

Do this and you'd be good to the goods. No decimal number returned. I am elated.

Sub solver_binary_constraint()
'
' solver_binary_constraint Macro
'

'
SolverReset
SolverOptions MaxTime:=0, Iterations:=0, Precision:=0.000001, Convergence:= _
0.0001, StepThru:=False, Scaling:=False, AssumeNonNeg:=True, Derivatives:=1
SolverOptions PopulationSize:=100, RandomSeed:=0, MutationRate:=0.075, Multistart _
:=False, RequireBounds:=True, MaxSubproblems:=0, MaxIntegerSols:=0, _
IntTolerance:=1, SolveWithout:=False, MaxTimeNoImp:=30


SolverOk SetCell:="$E$18", MaxMinVal:=3, ValueOf:=1226873, ByChange:= _
"$E$11:$E$17", Engine:=2, EngineDesc:="Simplex LP"
SolverAdd CellRef:="$E$11:$E$17", Relation:=5, FormulaText:="binary"
Solversolve

End Sub