COMBINA
Formulas / COMBINACount combinations with repetitions allowed.
=COMBINA(number, number_chosen)
- number - required, must be greater than 0 and greater than or equal to number_chosen
- number_chosen - required, must not be less than 0
Examples
=COMBINA(10,3) returns 220In this example, the COMBINA function is used to calculate the number of possible combinations from a set of 10 items taken 3 at a time. The result is 220, because there are 220 distinct combinations of 3 items that can be taken from the set of 10.
=COMBINA(B6,C6)In this example, the COMBINA function is used to calculate the number of possible combinations from a set of items in column B. The number of items to be chosen is specified in the corresponding cell in column C. For example, if cell B6 contains the set {A, B, C, D} and cell C6 contains the number 2, the result of the COMBINA function will be 6, since there are 6 combinations of 2 items that can be taken from the set {A, B, C, D}.
Need help with Formulas?
Summary
The COMBINA function is used to calculate the number of combinations of items. It requires two arguments, number and number_chosen, which must be greater than or equal to 0.
- The COMBINA function requires two arguments: number and number_chosen.
- The number argument is the total number of items and the number_chosen argument is the number of items in each combination.
- The COMBINA function returns the number of combinations with repetitions allowed in a given set. To count combinations that do not have repetitions use COMBIN.
Frequently Asked Questions
What is the COMBINA function?
What errors may occur when using the COMBINA function?
How can I prevent errors when using the COMBINA function?
- Make sure both arguments meet the constraints of the COMBINA formula.
- Ensure both arguments are numbers, not text or blank values.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.