Advanced Sum Formula

[jedi160]

Hi all,

Is there any formula that can analyze a set of numbers and identify which numbers are equal to a certain value? For example, if I know that in a set of 47 numbers, some combination of them is equal to 100, can I identify which ones?

Thanks,
Patrick

 

[Peter_SSs]

Try these links:
http://www.mrexcel.com/pc09.shtml
http://www.mrexcel.com/board2/viewtopic.php?t=46187
http://www.tek-tips.com/faqs.cfm?fid=4742

 

[jedi160]

Thanks!