Help with formula

  • Thread starter Thread starter Brandon
  • Start date Start date
B

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
 
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:
 
Back
Top