Microsoft Excel 2007 Formula to Return a Group of Numbers To Total A Specific Amount RRS feed

  • Question

  • Is there a formula in Microsoft Excel 2007 where I can select (or highlight) a group of numbers that I want selected numbers taken from to amount to a total which I would have specified? 


    Example, if I have the following numbers; 20, 15, 60, 30, 25, 65 and I want to determine which of those numbers amount to a total of 110. The answer should give me 20, 60, 30.


    This could be used to match an invoice amount (of say $100) with part payments (eg $50, $40, $10) to total the invoice amount.

    Monday, February 21, 2011 11:45 AM