How to sum in Excel until reach sum value, and know stop in what coloumn?

[phoenix0708081]

Hi, i need help. I dont know how to sum in excel until reach some value? and that stop in coloum?
I attach the file below

 

[vletm]

phoenix0708081
Did You read Forum Rules?

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

How to get the Best Results at Chandoo.org

• Quickly search the Web and Chandoo.org for help before posting. It is quite possible that your problem has been solved by someone else.

... and You should find this weeks

Sum each row until value is eached

I have a table like in the attached and I am looking to add a formula that can sum up the value column one row at a time, and if the total equals the target value, then return the date on that row. In the example sheet I've added the date it should return Does anyone know how to go about this...

chandoo.org