Probability Sum?

[sinn3r]

Hello,

Say I have a range of data in column A as follows:

A
1 53,448.30
2 21,945.00
3 30,242.10
4 21,470.40
5 20,464.50
6 10,997.70

I want to know if there is a way I can get Excel to find out the cells that results in a total of 54413.10. In this case the answer is A2, A3 and A6. Of course, in some cases there could be even more than one range of cells that result in the same total.

This will be helpful for offsetting unallocated receipts.

I hope the idea is clear.

Help?

[VBA Noob]

See if link helps

http://www.dailydoseofexcel.com/arch...sum-to-target/

VBA Noob

[sinn3r]

People like you deserve a place in heaven