+ Reply to Thread
Results 1 to 11 of 11

Sum of 2 cells in a column equal a specific number

  1. 06-11-2011, 11:24 PM #1
    philippe1
    philippe1 is offline
    Registered User
    Join Date
    06-11-2011
    Location
    san francisco
    MS-Off Ver
    Excel 2007
    Posts
    9

    Sum of 2 cells in a column equal a specific number

    I am looking for a formula that would locate 2 cells in a column of numbers.
    The sum of these 2 cells should equal a specific number (456 for example).
    Thank you for your help.
    Reply With QuoteRegister To Reply
  2. 06-12-2011, 12:09 AM #2
    Haseeb Avarakkan
    Haseeb Avarakkan is offline
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    365
    Posts
    2,243

    Re: Sum of 2 cells in a column equal a specific number

    Hello Philippe1, Welcome to the forum!

    Please attach a sample file with expecting result..!
    Regards,
    Haseeb Avarakkan
    __________________________________
    "Feedback is the breakfast of champions"
    Reply With QuoteRegister To Reply
  3. 06-12-2011, 01:48 AM #3
    philippe1
    philippe1 is offline
    Registered User
    Join Date
    06-11-2011
    Location
    san francisco
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Sum of 2 cells in a column equal a specific number

    Hi, Attached is a excel file with a simple example of what I am looking for.
    Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 06-12-2011, 02:15 AM #4
    Mordred
    Mordred is offline
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Sum of 2 cells in a column equal a specific number

    Let me know if this works for you:
    Please Login or Register  to view this content.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---
    Reply With QuoteRegister To Reply
  5. 06-12-2011, 02:29 AM #5
    Mordred
    Mordred is offline
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Sum of 2 cells in a column equal a specific number

    Here's one with a button to activate the sum formula.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 06-12-2011, 02:43 AM #6
    philippe1
    philippe1 is offline
    Registered User
    Join Date
    06-11-2011
    Location
    san francisco
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Sum of 2 cells in a column equal a specific number

    Thank you Mordred, it works fine, thanks for the time spent to create this code. It will save me a lot of time.
    Reply With QuoteRegister To Reply
  7. 06-12-2011, 02:45 AM #7
    Mordred
    Mordred is offline
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Sum of 2 cells in a column equal a specific number

    Hi philippe, see if the next workbook is better or not. It places the found number to the right of both numbers being added.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 06-12-2011, 02:54 AM #8
    Mordred
    Mordred is offline
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Sum of 2 cells in a column equal a specific number

    The solution I provided to you works but does take some time if there are thousands of rows. I just tested it on 5000 rows and it took about 1 minute to complete.
    Reply With QuoteRegister To Reply
  9. 06-12-2011, 02:07 PM #9
    philippe1
    philippe1 is offline
    Registered User
    Join Date
    06-11-2011
    Location
    san francisco
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Sum of 2 cells in a column equal a specific number

    Thanks Mordred, this new version is even better, my rows are about 1000, so it is working fine.
    I guess we can consider this thread SOLVED but I don't know how to do that since I am new to this forum.
    Last edited by philippe1; 06-12-2011 at 02:11 PM.
    Reply With QuoteRegister To Reply
  10. 06-12-2011, 05:27 PM #10
    abishekmouli88
    abishekmouli88 is offline
    Registered User
    Join Date
    05-11-2011
    Location
    College Station, Texas
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    42

    Re: Sum of 2 cells in a column equal a specific number

    Hello,

    Please find the attached file and see if it helps. This gives you the sum you need and also the address of the sum of cells. This can be done for any number of rows.

    Thanks and Best Regards,
    Abi
    Attached Files Attached Files
    Abi
    Reply With QuoteRegister To Reply
  11. 06-14-2011, 01:43 AM #11
    philippe1
    philippe1 is offline
    Registered User
    Join Date
    06-11-2011
    Location
    san francisco
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Sum of 2 cells in a column equal a specific number

    Thanks Abi, your file works fine.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1