+ Reply to Thread
Results 1 to 2 of 2

To Sum Cells Until Preset Value Is Reached

  1. #1
    Registered User
    Join Date
    09-23-2010
    Location
    Banja Luka
    MS-Off Ver
    Excel 2003
    Posts
    1

    To Sum Cells Until Preset Value Is Reached

    Hello,
    I have a spreadsheet with some values in column A.
    I need to be able to sum the values in columnA until preset value are reached.

    I wants to sum of 5 cells is 16, how to find cells that correspond to sum 16.


    Example :

    ColumnA
    1
    2
    3
    4
    5
    6

    Thanks in advance

    Dado

  2. #2
    Forum Contributor
    Join Date
    05-27-2008
    Location
    Newcastle Upon Tyne UK
    MS-Off Ver
    XP Excel 2003
    Posts
    105

    Re: To Sum Cells Until Preset Value Is Reached

    Hi welcome to the board

    In the example you have shown there are several combinations which make 16
    1,2,3,4,6
    5,3,2,6

    which one do you want?

    edvwvw

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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