EXCEL - COUNT help

[alisaheb]

I am working in excel 2003 where my data is like:

1-jul 2- jul 3-jul 4-jul total credit bal by days
0.9 0.1 0.4 0.5 1.9 1.1 0.8 xx

In place of xx above, I need a formula where it should look from 4-jul to
1-jul and give number of days from when bal is due. In above example answer
sholud be 2 as bal 0.8 falls within sum of 4-jul + 3-jul.

Need help from experts.

 

[Max]

One play ..

Assume table as posted is within A1:H2
In A3: =IF(SUM(A2:$D2)>=$G$2,COLUMNS($A:A),"")
Copy A3 to D3

Then in H2: =IF(G2<=0,0,4-MAX(A33)+1)
returns the required "By days" count for the balance
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik