Summing to a point

[hardgrafting]

Hi,

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

Number of cats	7	8	10	11	12
Cumulative cats	7	15	25	8	0
Cap on the number of cats	33

<tbody>
</tbody>

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.