Find cells within worksheet that add up to a certain value

Discussion in 'Microsoft Excel Misc' started by Ashley P., Oct 22, 2009.

  1. Ashley P.

    Ashley P. Guest

    I have a column with values in 65 cells, and I'm trying to find out which
    ones (if any) add up to a specific amount. It could be any two or more of the
    cells, or none at all. I really don't want to try adding them all manually to
    see if I can find the amount I'm trying to match. Can I use Excel to do this
    instead?
     
    Ashley P., Oct 22, 2009
    #1
    1. Advertisements

  2. Ashley P.

    Mike H Guest

    Hi.

    Look here

    http://www.tushar-mehta.com/excel/templates/match_values/index.html#Solver_Template

    Mike

    "Ashley P." wrote:

    > I have a column with values in 65 cells, and I'm trying to find out which
    > ones (if any) add up to a specific amount. It could be any two or more of the
    > cells, or none at all. I really don't want to try adding them all manually to
    > see if I can find the amount I'm trying to match. Can I use Excel to do this
    > instead?
     
    Mike H, Oct 22, 2009
    #2
    1. Advertisements

  3. Ashley P.

    TeddyBear

    Joined:
    May 16, 2013
    Likes Received:
    0
    Try SumMatch (Excel Add in) from SumMatch com


     
    TeddyBear, May 16, 2013
    #3
  4. Ashley P.

    TeddyBear

    Joined:
    May 16, 2013
    Likes Received:
    0
    try SumMatch from SumMatch com (Excel Add in). Is the best solution in the market.
     
    TeddyBear, May 16, 2013
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.