# Excel COMBINA Function

The Excel COMBINA function returns the number of combinations with repetitions *allowed*. To count combinations that *do not* allow repetitions, use the COMBIN function.

**number**- The total number of items.**number_chosen**- The number of items in each combination.

The COMBINA function returns the number of combinations for a given number of items. A combination is a group of items where order *does not* matter. There are two kinds of combinations:

- Combinations that
*do not*allow repetitions (e.g. 123) - Combinations that
*do*allow repetitions (e.g. 333)

The COMBINA function *allows* repetitions. To count combinations that *do not* allow repetitions, use the COMBIN function. To count permutations (combinations where order *does* matter) see the PERMUT function.

### Example

To use COMBINA, specify the total number of items and "number chosen", which represents the number of items in each combination. For example, to calculate total 3-number combinations of numbers between 0-9, you can use a formula like this:

=COMBINA(10,3) // returns 220

The *number* argument is 10 since there are ten numbers between 0 and 9, and and *number_chosen* is 3, since there are three numbers each combination. This result can be seen in cell D8 in the example shown.

### Notes

- A combination is a group of items in any order. If order matters, use the PERMUT function.
- Arguments that contain decimal values are truncated to integers.
- COMBINA returns a #VALUE! error value if either argument is not numeric.

## Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.