How do I return a column reference once a cumulative total is reached

[EN_mouch]

I've currently got a spreadsheet with months along the top (columns) and then for each line item a different task I work on. For example

Column A2 = "Create Plans"
Of which I have 45 in total (Subtotal in B2)

I then have Months Jan (Col C) through to Dec (Col N), in row 2 I will then detail which months I actually work on the plans so say I start in Feb (D2 = 10), work on 30 more in Mar (E2=30) and complete the final 5 in Apr (F2=5)

I'm trying to figure out a way of returning the column number at which the cumulative total reaches 45.... I've tried using min and max look ups but if I extend my selection to column N then then max only returns the final date I have zero's in rather than the column I actually achieve the total.

I've had a good look around and it appears as though I could do with something similar to this control+shift+enter...

=MATCH(TRUE,SUBTOTAL(9,OFFSET(A1,0,0,ROW(A1:A7)-CELL("Row",A1)+1))>=100000,0)

except that it would work over multiple columns rather than data fed down the list.

Any help would be truely appreciated!

Thanks

[dip11]

Can you provide an example spreadsheet with exactly how it looks currently and where you want the desired result to displaz

[EN_mouch]

here is an example of what I'm after....

thanksCumulative Date Identification (1).xls

[daddylonglegs]

Try this formula for Q2

=INDEX(D$1:P$1,MATCH(TRUE,D2:P2<>"",0))

confirmed with CTRL+SHIFT+ENTER

and this for R2

=INDEX(D$1:P$1,MATCH(TRUE,SUBTOTAL(9,OFFSET(D2,0,0,1,COLUMN(D2:P2)-COLUMN(D2)+1))>=B2,0))

also with CTRL+SHIFT+ENTER

[EN_mouch]

That's worked thanks... any suggestions for columns S and T?