Combinations for match of predefined sum

I am trying to figure out a formula or macro or function in Excel to calculate the permutations (possible combinations) of a set of numbers and compare the result with a predefined number. Does anyone know how to do this or where I need to go to find more information?