Search range of numbers for amounts that total a given

[Mike Briscoe]

I would like to be able to search a range of numbers to
identify those amounts that total a given amount. There
could even be multiple combinations that would work.

An example would be that given a column that contain the
numbers 25, 50, 13, 38, 15, 8 and I wanted to search for
those amounts that total 78. The result would identify
and possibly mark 50, 13, & 15.

Is this possible?

Thanks in advance for your help!!!

 

[Frank Kabel]

Hi
how many values do you want to search(>70?). Also: do you want to
return all possible combinations?