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

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

2. 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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•