# Find cells in range that sum up to certain value

1. ## 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?!

2. ## 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

3. ## 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!

4. ## 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. ## 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. ## 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. ## 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?

##### Users Browsing this Thread

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

#### 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