Results 1 to 3 of 3

Thread: Help to find numbers that equal a predetermined sum

  1. #1

    Help to find numbers that equal a predetermined sum



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

    This may be an odd question and I hope I can explain it clearly. Is there a formula that would identify numbers in a column where the sum of those numbers would equal a predetermined amount? For instance, if my office receives a payment from a customer for $1275, and the customer has numerous invoices open where some combination of some of those invoices equals $1275, is there a formula to find that? And in doing so I would know which invoices I could apply the payment to without having any leftover amount from the payment.

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    That's a an often asked question. There's no simple way unfortunately, you could maybe use Solver
    Hope that helps

    Roy

  3. #3
    Acolyte Canapone's Avatar
    Join Date
    Oct 2011
    Location
    Italy
    Posts
    97
    Articles
    0
    Hi, here you can download an alternative solution, it's an addin to be installed on your Excel

    http://www.tushar-mehta.com/excel/so...rget/index.htm

    Regards

Posting Permissions

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