+ Reply to Thread
Results 1 to 6 of 6

Finding a specific sum from range of numbers

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    Fort Lauderale
    MS-Off Ver
    Excel 2003
    Posts
    8

    Finding a specific sum from range of numbers

    We get checks with a specific amount but with no listing of what is being paid. Basically what I am looking for, if possible is to see what combination of invoice amounts will lead to a specific number (check amount). Thanks for any help.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Finding a specific sum from range of numbers

    could you be more specific, please

  3. #3
    Registered User
    Join Date
    05-09-2012
    Location
    Fort Lauderale
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Finding a specific sum from range of numbers

    I have a customer with a list of some 20 open invoices of various amounts. I receive a check from the customer with a specific amount. I need to find a way to see if there is a set of numbers from the open invoices that will match the specific check amount.

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Finding a specific sum from range of numbers

    function match

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Finding a specific sum from range of numbers

    What's the reasonable maximum number of open invoices?

    What's the reasonable maximum number of open invoices that a given check could cover?
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Finding a specific sum from range of numbers

    Do you use a date field in your data? Will the customer be paying off the oldest invoice first? What if there are multiple ways to add different invoices to the payment amount? What is there is NO way to add any/all of the invoices to the payment amount?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding Max number within a specific range of numbers
    By sjjna in forum Excel General
    Replies: 8
    Last Post: 04-03-2015, 10:20 AM
  2. Finding TWO numbers from a range of numbers to match a target value
    By Eero in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2014, 10:08 AM
  3. Formula for finding a specific sum from a range of numbers?
    By jdawg1536 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2014, 04:19 AM
  4. Formula Finding String with Specific Letters and Numbers
    By jpedges38 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-06-2012, 08:56 PM
  5. Finding a Specific Sum in a List of Numbers
    By pugsly8422 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-03-2012, 10:25 AM
  6. Replies: 0
    Last Post: 01-29-2012, 10:05 PM
  7. Finding Median in Series of Numbers for Specific Records
    By vinaykam82 in forum Excel General
    Replies: 3
    Last Post: 12-04-2011, 04:02 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1