Let's wait for the experts to provide the solution. It's not the regular IF and SUM operations because my understanding is the daily goal (column c) remains static until the first order had been filled, any remaining balance (first order less accumulated goal in Col C) will then be added to the next goal in column B.
|