Summing to a point

[hardgrafting]

Hi,

I have the below data that I want to sum, but only to a certain point:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Number of cats[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cumulative cats[/TD]
[TD]7[/TD]
[TD]15[/TD]
[TD]25[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cap on the number of cats[/TD]
[TD]33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I have information on the number of cats in each house, as can be seen it is 7 in one house, 8 in the other house, 11 in another house and 12 in another house. I am adding them cumulatively in the column below, as can be seen from the 7-15-25.

However, there is a cap on the number of cats in the homes. As such, the house with 11 is only allowed to have 8 cats, since adding 8 to 25 makes it 33. Can this be done as a formula? Which will sum until a point and then at the number which exceeds the cumulative cap, will get reduced to the cap?

 

[hardgrafting]

Thanks, but doesnt seem to work when I apply it in cell B3 is the formula definately correct?

 

[Fluff]

Yes, the results shown are returned by those formulae.