Count 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

`=COMBINA(10,3) returns 220`

In 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}.

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.

The COMBINA function is a Sourcetable formula that helps count how many combinations there are with repetitions.

The COMBINA function may return an error if either of the arguments do not meet the function's constraints. If either argument is outside the constraints, a #NUM! error is returned. If either argument is a non-number, a #VALUE! error is returned.

- Make sure both arguments meet the constraints of the COMBINA formula.
- Ensure both arguments are numbers, not text or blank values.

Drop CSV