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

Psilver1

New member
Joined
Oct 31, 2012
Messages
1
Reaction score
0
Points
0
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 B2:D2 less than value in A2
7968
10637
1472
8705
Total of Sum of B2:D2 less than value in A3
10762
12807
11114
14191
Total of Sum of B2:D2 less than value in A4
6069
795
2815
10160
Total of Sum of B2:D2 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

New member
Joined
Feb 10, 2012
Messages
190
Reaction score
0
Points
0
Location
Utah, USA
Excel Version(s)
Version 2002 Build 12527.20194
In your above example. the first row looks like
88601368392812125

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
 
Top