any such formula?

[lee h]

Is there a function/formula that would look at a series of numbers and identify if any combination added up to something?
I am looking for something where I see someone added/subtracted a number within a cell, I know the file the number comes from, but there are no cell references in the cell … it is just a hard coded number.

 

[VoG]

See if this helps http://www.tushar-mehta.com/excel/templates/match_values/index.html