Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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. #2
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    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
  •