Help in developing Formula for count

[hemantsharma88]

Hi frnds need your help, below is query

in below data i want to count the no of months till the amount sum upto alleast 25. like in this case count is 5 because till may amount is 25 plus. how can i put this in formula as i have more than 200 rows and hve to calculate till wht month desired amount is achieved which is 25 in this case.

Month	amt
jan	12
feb	3
mar	4
apr	5
may	6
june	7
july	8

<TBODY>
</TBODY>

 

[James006]

Hi,

You can have in cell C2:

=sum($B$2:B2)

and then copy formula down in Column C

HTH

 

[Robert Mika]

Hi frnds need your help, below is query

in below data i want to count the no of months till the amount sum upto alleast 25. like in this case count is 5 because till may amount is 25 plus. how can i put this in formula as i have more than 200 rows and hve to calculate till wht month desired amount is achieved which is 25 in this case.

Month	amt
jan	12
feb	3
mar	4
apr	5
may	6
june	7
july	8

<TBODY>
</TBODY>

Hello and welcome,
=MIN(IF(SUBTOTAL(109,OFFSET(B2,0,0,ROW(B2:B200)-ROW(A2)+1,1))>C1,ROW(B2:B200)-ROW(B2)+1))
Confirm COntrol+shift+enter