Results 1 to 3 of 3

Thread: find specifc total among group of cells with numbers

  1. #1

    find specifc total among group of cells with numbers



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

    Using Excel 2003, is there a way to find a specific total among a group of numbers in cells? Let’s say I have a total, e.g., $45.00, and a group of cells with these numbers:

    30.00
    68.00
    15.00

    Is there a way I can find out which, if any, of these numbers total $45.00?

    Thanks!

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    675
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Monelle, it a few days since you asked this and there's been no responses, if you are still in need of a suggestion have a look at this similar question asked a few years ago on another forum with a solution that uses the Excel solver add-in.

    http://superuser.com/questions/20492...-a-given-total

  3. #3
    In excel 2007, If ... End if can be used to check whether two totals equal the given value.
    If there are more numbers, Do... Loop an be used.
    I am a learner still.

Posting Permissions

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