Formula that counts cells and returns a number

[blburden]

I've got a table that shows how long it takes to recover an intial investement of $999.79 and what I'm trying to do is figure out a formula that will tell me exactly how many months it takes to recoup my initial investment. For instance, in this example a $999.79 investment would take approximately 6.5 months to recoup. I need a formula that sums the values in the rows until it reaches the initial investment amount and then returns the number of months it took. I've attached a picture of the table. The initial investment amount is located in cell B3 in the worksheet. Can anyone help out? Thanks.

Untitled.jpg

[dilipandey]

Hi Bluburden,

Welcome to the forum.

Please upload a excel workbook not the image so that people can give a quick practical shot at it... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[blburden]

Dear DILIPandey,

I have attached the Excel spreadsheet. The cell I'm trying to place the calculation in is cell G21.

[MarvinP]

Hi blburden and welcome to the forum,

See if the attached does it for you. I made it all payments greater than a penny.

[blburden]

Dear DILIPandey,

Thank you for your response. The actual correct answer would be 19 months and your answer gives me 24. If you calculate months 1 - 19 in the table, you come up with $1,769.38 and my initial investment was $1,788 (Cell B3). So it would take me 19 months to recoup my investment. Is there any way to create a calculation that would keep counting the cells B13 through M18 until it reaches the amount in cell B3?

Thanks!