Finding multiple cells that add up to a desired amount
I am trying to find the cells in a column that add up a certain number within $1.00. I am reconciling monthly sales for the past four years and trying to find the differences between reported sales and what my accounting program currently shows.
I have attached a sample of one month's reconciliation. In this example "N349" is the target number and the rows in green and the numbers I found to add up to me target.
I know there has to be a formula that can do this for me. Please help!