Help - Simple Problem

Hi All

I know this should be simple but heres the deal. I have an expected completion amount per day. I have a list of outstanding items in a column starting from Day 10 + down to day 2.
I need the Expected completion to be taken off the outstanding items working down.
e.g. If i have an Expected Completion of 20 i would need to following outcome
Outstanding items After Expected completions taken off
Day 10+ 2 0
Day 9 1 0
Day 8 2 0
Day 7 10 0
Day 6 11 5

Assuming that you have headers on row 1, a blank row 2, and your Days start on row 3

in C2 put your 20

in C3 put =IF(C2>B3,C2-B3,0) and formula-drag that to the end of your days.

--

Originally Posted by Steel Monkey

Hi All

I know this should be simple but heres the deal. I have an expected completion amount per day. I have a list of outstanding items in a column starting from Day 10 + down to day 2.
I need the Expected completion to be taken off the outstanding items working down.
e.g. If i have an Expected Completion of 20 i would need to following outcome
Outstanding items After Expected completions taken off
Day 10+ 2 0
Day 9 1 0
Day 8 2 0
Day 7 10 0
Day 6 11 5

try

=IF(C$2-SUM(B$3:B3)>0,"",-C$2+SUM(B$3:B3))

in cell C3 and drag down

--

Originally Posted by Steel Monkey

Hi Bryan,
Thank you kindly for your reply

This formula gives me the expected completion as opposed to items outstanding after the expected completion has been taken off.
The formula gives me the following results:
18
17
7
0

When i need the following results
0
0
0
4

So the expected completions are taken off the oldest down to earliest. So if the expected completion was reached(20) we would only have 4 left on day 8 and any earlier then day 8 would remain the same(as none of these would have been completed). Hmmmm hope this makes sense