+ Reply to Thread
Results 1 to 7 of 7

Find cells in range that sum up to certain value

  1. #1
    Registered User
    Join Date
    09-25-2015
    Location
    Louisiana
    MS-Off Ver
    MS Office 2013
    Posts
    29

    Find cells in range that sum up to certain value

    Last post must have had an error. Trying again.

    I need to search one column (N) with a maybe 300 rows and find the cells that sum up to a certain value.

    I have a variance in my G/L reconciliation and I'm hoping I can find what makes up this variance. It's all related to journal entries prior to my employment and the auditors are here. Any help please?!

    Thanks in advance!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Find cells in range that sum up to certain value

    Is there any limit of cells number (these which shall sum to given value) - if it is small number: like 2,3,4 cells - not bad
    if more (or a lot - like 50) - rather tough

    Are values only positive (or only negative) or mixed? same sign is easier, mixed makes tougher task.

    Have a look into older thread - may be the solution presented there would work for you: http://www.excelforum.com/excel-prog...ing-macro.html

    if not, consider attaching representative sample workbook
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    09-25-2015
    Location
    Louisiana
    MS-Off Ver
    MS Office 2013
    Posts
    29

    Re: Find cells in range that sum up to certain value

    The signs vary and the number count in range is 435. I've used a method before but it was slow in dealing with the amount of data I typically use.

    I added attached sample via link below where I am typing now "Manage Attachments"

    The attachment drop down box above where I am typing this post isn't allowing me to attach.

    Let me know if I successfully attached the sample file. Thank you!
    Attached Files Attached Files

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Find cells in range that sum up to certain value

    Yess, the file is there.
    Unfortunately, I'm just about to go offline.
    So will not touch this for at least "a good while".

    But either for me returning later of some other helper:
    What value are you trying to "collect"?
    I assume, you need exact match not +/- 10
    even not +/- 0.01.
    And finally - have you (I haven't :-P ) checked attachment from link provided above?

  5. #5
    Registered User
    Join Date
    09-25-2015
    Location
    Louisiana
    MS-Off Ver
    MS Office 2013
    Posts
    29

    Re: Find cells in range that sum up to certain value

    I need to find -9,101.80

    I haven't checked the link yet. Will check it out later today.

    Thank you!

  6. #6
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Find cells in range that sum up to certain value

    OK, once you check - share if it worked.
    And I'm really swithing power off, because probably I finished interesting discussion with one of my personal gurus: MrShorty here: www.excelforum.com/showthread.php?t=1133290 .

  7. #7
    Registered User
    Join Date
    09-25-2015
    Location
    Louisiana
    MS-Off Ver
    MS Office 2013
    Posts
    29

    Re: Find cells in range that sum up to certain value

    The data sample I sent you will not reconcile to zero. There is other data that I'm reconciling against and is not set up the same way as it comes from a different program.

    I simply was hoping there was a way for Excel to show me what cells sum up to equal -9,101.80

    I've checked out the last link you sent. I'm not the best with some macros. Any way your macro in file "Recon with macro v1.4" from link above could work for me?

    Any other ideas?

+ 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. Code look through range of cells, find blanks & delete cell range in the same row,
    By EagleInsight in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-10-2014, 11:24 AM
  2. Find text in range of cells and add to table if it does not exist in range
    By dgadler1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2013, 12:54 PM
  3. shift range of cells to left if find the range of empty do while
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2012, 09:25 AM
  4. Find max and min value in range of cells using VBA
    By proepert in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-07-2010, 10:10 AM
  5. Replies: 3
    Last Post: 02-02-2010, 10:54 AM
  6. Find Range of Cells using a Criteria
    By newbie1234 in forum Excel General
    Replies: 6
    Last Post: 12-28-2008, 12:43 AM
  7. Find value in a range of cells
    By Geuis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2005, 09:31 AM
  8. Find string in range or cells
    By FVG in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-23-2005, 06:31 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