Snasui Excel Forum

Hi Dear,

I need your help how to sum until reach a certain value of a cell.
I have attached a template.
The result in color cells

Thanks

Here's an attached

C2
=IF(SUM(B$1:B1)<$A$2,MIN($A$2,SUM(B$2:B2)),"")

Thank you