Hi
I have been trying to add up numbers (in Column B) from a series (Column A); until the sum of added numbers have an exact match with a specific target (Cell E2).
P.S. I need to add only the necessary numbers so that the sum doesn't exceed or fall short of the target.
To clarify my requirement, I have shown cumulative sums of the series in Column C; where it shows why the red colored numbers of the series did not add up in the Column B.

Thanks in advance!
I have been trying to add up numbers (in Column B) from a series (Column A); until the sum of added numbers have an exact match with a specific target (Cell E2).
P.S. I need to add only the necessary numbers so that the sum doesn't exceed or fall short of the target.
To clarify my requirement, I have shown cumulative sums of the series in Column C; where it shows why the red colored numbers of the series did not add up in the Column B.

Thanks in advance!
Last edited: