I am trying to find a formula that will give me the cells that add up to a given value. Think of a reconciliation process in which you are off by x amount and x can be the sum of multiple cells positive and negative. Is there an easy way or a formula that can help with that?

I don't know of a single formula to perform that action. If you had 100 cells of values there could be multiple combinations of cells with numbers that give the same answer. If you wanted, you could think it through and come up with some type of algorithm.

Howdy. One possibility is to use Goal Seek (Analysis ToolPak). But it would take some planning to do so.

If I were to attempt this, I might consider using VBA instead of an Excel-function/formula approach.

There is no easy way and no formula. VBA will be required. The best solution I saw - too long ago now to remember where - used recursion. It was only a dozen or two lines of code and worked quickly and very well. It was limited to about 2 dozen input values however, 'cause after that it took 'forever'. HTH

Tushar Mehta has just posted a template that does this very thing:

Thank you all for your response, the template really helps!