Help - Simple Problem

[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

 

[Bryan Hessey]

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.

--

 

[Steel Monkey]

Hi Bryan,
Thank you kindly for your reply

This formula gives me the expected completion as opposed to item
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 lef
on day 8 and any earlier then day 8 would remain the same(as none o
these would have been completed). Hmmmm hope this makes sens

 

[Bryan Hessey]

try

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

in cell C3 and drag down