Difficulty adding 3 adjacent cells so that their summed values are > a #

[Psilver1]

I am attempting to add 3 cells together in 3 seperate columns and have the total value within the cell not to exceed a fixed value. I have placed an example below to see if someone new of a better formula to use. The columns of B,C & D are random numbers and can be chnaged but Excel would need to input its own values. Column A is the fixed value for each row. Thanks

Natural Habitat m²	A	B	C	Total
8860	1368	3928	12125	Total of Sum of B22 less than value in A2
7968	10637	1472	8705	Total of Sum of B22 less than value in A3
10762	12807	11114	14191	Total of Sum of B22 less than value in A4
6069	795	2815	10160	Total of Sum of B22 less than value in A5
13643	3070	7284	6969	Total of Sum of B2D:2 less than value in A6
4001	888	11231	11178	Total of Sum of B2D:2 less than value in A7
8334	5941	7357	9400	Total of Sum of B2D:2 less than value in A8
12201	6044	7004	6313	Total of Sum of B2D:2 less than value in A9

 

[Simi]

In your above example. the first row looks like

8860

1368

3928

12125

The first number is your Natural Habitat column that will be used as your number to compare against.
so in the cell to the right of 12125, you should put something like. =IF(SUM(B2: D2)>A2, SUM(B2: D2),"sum is less than original number")

I hope that helps,

Simi