Identify defined amount derived from available list of numbers

[earthworm]

I have a below data . There is a total amount of 46286 which is an addition of some number present in a list.

How can I identify of which amount when total together leads to my above mentioned answer

30,000.00
102,000.00
9,749.00
40,877.00
100,000.00
120,000.00
37,846.00
8,440.00
83,863.00
25,000.00
40,000.00
3,053.00
12,044.00
25,348.00
21,322.00
42,062.00
12,394.00
15,998.00
54,510.00
30,526.00
141,726.00
77,863.00
15,000.00
10,813.00
10,000.00
10,289.00
32,706.00
118,723.00
70,942.00
54,755.00
64,195.00
10,175.00
25,001.00
30,610.00
31,541.00
38,745.00
54,066.00
32,480.00
24,999.00
64,333.00
51,337.00
46,112.00
129,669.00
10,000.00
15,000.00
50,000.00
57,816.00
110,000.00
327,060.00

 

[Joe4]

You would use SOLVER to do this.
See: http://www.k2e.com/tech-update/tips/147-using-excel-to-identify-entries-that-add-to-a-specific-value

 

[earthworm]

You would use SOLVER to do this.
See: http://www.k2e.com/tech-update/tips/147-using-excel-to-identify-entries-that-add-to-a-specific-value

It has a limitation

1. Solver limits you to 200 variables, and
2. Solver limits you to 100 constraint

Do i have any other option like vba ?

 

[Joe4]

You only have 49 variables in your example (well under 200).
Are you saying this really isn't representative of your real problem?

If you really do have more than 200 variables, reach this discussion here for various options: https://stackoverflow.com/questions/24533696/excel-solver-more-than-200-data-using-vba

 

[earthworm]

You only have 49 variables in your example (well under 200).
Are you saying this really isn't representative of your real problem?

If you really do have more than 200 variables, reach this discussion here for various options: https://stackoverflow.com/questions/24533696/excel-solver-more-than-200-data-using-vba

thanks . I have installed open solver . Can you please post a tutorial or post video how to use it in my given scenario. as i am lost

 

[Joe4]

I had never used SOLVER before myself until this question. I followed the instructions given in the link I posted up in my first reply, and was able to do it on your problem.
Follow those instructions, they are pretty straightforward.