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