Count of cells that can be summed before a value is reached or exceeded?

Wondering if there is a way to do this without using macros...

I have a table of values listed where columns are dates (earliest on the left) and rows contain values. I am looking for a formula to return the number of values, counted left to right, it would take on a given row it would take to meet another value....awkward explanation;

comma delimited example here, i cannot upload files sorry. Copy paste and text-to-col starting in cell A1

Please Login or Register  to view this content.

Column B shows where the formula would be. The number represents how many cells (counted from left to right) in range D:G can be summed before the value in column A is reached or exceeded. Oh also it needs to skip blanks (values in columns C and D can be blank with values starting in E)

Thanks in advance!

Does this work for you?

=IF(MATCH(A2,$C2:$G2)=5, MATCH(MAX($C2:$G2), $C2:$G2,0),MATCH(A2,$C2:$G2))
5 is the number of columns/numbers

if you are fine with the formula returning a value from 1st row (in case of your data, Date 1 through 5), then try this ARRAY formula in H2, then drag-fill down:

Please Login or Register  to view this content.