hardgrafting
New Member
- Joined
- Feb 6, 2017
- Messages
- 25
Hi,
I have the below data that I want to sum, but only to a certain point:
<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?
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?