ramdon sum

[lx]

hi! i have a list of amounts on column A, and i have a total on column B, i am trying to create a program that sum the values on column A until ithe sum is equal to the amount on column b, any clue, i am really without clue about this!!

 

[tactps]

Welcome:
You could add conditional formatting to highlight the last cell that is less than or equal to column B:

Click on cell A1
From the format menu, choose conditional formatting.
Choose "formula is" and type in the following:
=SUM($A$1:$A1)<=$B$1
Choose a format

This will highlight those cells that add up to less than the value in cell B1.

Is that the sort of thing you're after?

 

[lx]

no that dont help what i am trying to do is this:

----A------- ---------B-----------
5000 9000
3000
1000
2000
4000




result of macro or formula: sum of a1+A5 is equal to b1 / sum of a1+a2+a3 is equal to b1. i want the posibles sum with A numbers that are equal to b1

 

[tactps]

There are a number of posts that deal with "combinations".

You could search for this and review them.

You shoud find some that allow you to list all of the combinations, which you can then add to see if they add to 9000.

 

[lx]

i found this link http://www.mrexcel.com/pc09.shtml

but i cannot make it work, i meant it work but dont show anything just the time that it took can someone help me in this, because this exactly waht i am trying to do, thanks

 

[lx]

thanks

i finally manage to get the example working, really good macro

 

[Harvey]

If I understand this right, you want to:

the first x values in column A that together sum the value in column B
(that is what your first post says)

or:

all combinations that together sum the value in column B.
Then my question is: where do you want to put this lists? This decides mainly if you want to use macro or not.
I never tried combinations but this should not be too hard if you understand a bit of VBA.