Find Cell address while using sum

Hello Everyone,

I am trying to figure out a formula that would allow me to find the cell address of the last number needed to make a maximum total. Say if column A was A1=5, A2=5, A3=5, A4=5, A5=5 right down the line, I want to find the address of the cell that makes the total 20 (so, A4). Or if I had an odd number that I wanted to find like 23 it would be A5. Even though that adds up to 25 the number 23 would be made in the cell. I am not sure if this is out of the realm of possibility but I hope it isn't.

Thank you all.

Hi

B1: 20 (or 23 - the total you want to find)
C1: =IF(SUM($A$1:A1)>=$B$1,ROW(),"") Copy down as required
D1: =CELL("address",INDIRECT("A"&MIN(C:C)))

HTH

rylo