Excel Function : COMBIN
Math and trigonometry
Returns the number of combinations for a given number of objects
Microsoft Excel Reference Page
Syntax and Description of the COMBIN Excel Function
COMBIN is an Excel function that returns the number of combinations (subsets) in a set of items. The syntax for the COMBIN function is: COMBIN(number, number_chosen) Where: number – is the total number of items in the set number_chosen – is the number of items in the subset For example, the formula =COMBIN(5,2) returns the value 10, meaning there are 10 possible combinations of 2 items from a set of 5 items.
About COMBIN Excel Function
COMBIN(number, number_chosen) The COMBIN function returns the number of combinations for a given number of items. For example, if you have 10 items and you want to choose 3 of them, the COMBIN function will return 120.