function which will sum up specified number of random cells from group of cells

[tomo]

Hi, is there an function which will sum up specified number of random cells from group of cells in order to match specific number?

For example: group of numbers in 5 cells - 1 2 3 4 5 Combine (sum) any TWO to GET value of 5!

[Aliw267]

This code does the trick;

Please Login or Register  to view this content.

Simply put the list of numbers in a column with the amount of combination's you want at the top (0 for all) then the target number below that followed by all of the numbers underneath, then highlight the cells and run the code.

[NBVC]

Aliw267,

Please note:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here