I am looking for an Excel function that identifies any combination of cells in a colum which when summarized will equate to a given number. For example in the attached spreadsheet, the given is 177.41. I need to find what combination of numbers equate to that. The simple answer is 29.26 plus 148.15 (highlighted yellow in the attached). But it could be a longer list and it could be a different combination of summarized numbers - not just two.
Is there such a function?