Help with formula

[Brandon]

I want to return the first date in which the sum of the previous columns
first exceeds inventory on hand (total). Should return 4/5 on this example.

Total Due Date 3/24 3/30 4/5 4/7 4/7
68 #N/A 10 50 20 30 30

I am using nested if's, but need to expand to more than 7 columns, using
excel 2003.

Thanks

 

[Stefi]

I couldn't find a single formula, but if you set up a helper row with this
formula in C3 and filled to the right:
=SUM($C2:C2)
then
=INDIRECT(ADDRESS(1,MATCH(A2,C3:G3,1)+1+2,4,1))
gives the required result.

--
Regards!
Stefi



„Brandon†ezt írta: