# Excel COMBIN Function

The Excel COMBIN function returns the number of combinations for a given number of items. The COMBIN function *does not* allow repetitions. To count combinations that *allow* repetitions, use the COMBINA function.

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

The COMBIN function returns the number of combinations for a given number of items. A combination is a group of items where order *does not* matter. The COMBIN function *does not* allow repetitions. To count combinations that *allow* repetitions, use the COMBINA function. To count permutations (combinations where order does matter) see the PERMUT function.

### Example

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

=COMBIN(10,3) // returns 120

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 chosen in 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.
- COMBIN returns a #VALUE! error value if either argument is not numeric.
- If number is less than number chosen, COMBIN returns #NUM!

## Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.