Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
From a set of integers from 1 to 49,
take 6 unique integers, that if we sum them up, this sum is equal to 150. Conditions: 1. The set numbers are integers from 1 to 49 2. subset size is 6 3. sum of the selected subset numbers is 150 My questions: A. How many sets (combinations) of 6 unique numbers exist that their sum is 150? B. Do you know of a function that can calculate that quantity of combinations, for different values of conditions (1), (2), & (3)? Thank you, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combinations | Excel Discussion (Misc queries) | |||
Sum of combinations | Excel Discussion (Misc queries) | |||
Possible Combinations | Excel Discussion (Misc queries) | |||
Combinations | Excel Worksheet Functions | |||
count combinations | Excel Discussion (Misc queries) |