number equal to

[tpkelley_no]

I have an excel work sheet with the following numbers. Do they have a way for excel to tell me what numbers sum up to 600?

500.00

300.00

350.00

250.00

50.00

3,225.00

4,675.00

 

[Joe4]

You can use Solver to do that.
See: Find all combinations of numbers that equal a given sum in Excel

 

[tpkelley_no]

I am getting an error with the follow formula: =FindSumCombinations(A6:A15,A3)

sum
49​
numbers
1​		#NAME?​
2​
3​
4​
5​
6​
7​
8​
9​
10​

 

[Joe4]

That is a custom user defined function. Did you copy the VBA code that is in the thread for that, and place it a new VBA module in your workbook?

Note that thread shows 3 different ways to do it.
Did you try the built-in "Solver" functionality? That does not require anything extra on your part.