Exceljet

Quick, clean, and to the point

Excel COMBINA Function

Excel COMBINA function
Summary 

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

Purpose 
Get number of combinations with repetitions
Return value 
Number of combinations as an integer
Syntax 
=COMBINA (number, number_chosen)
Arguments 
  • number - The total number of items.
  • number_chosen - The number of items in each combination.
Version 
Usage notes 

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:

  1. Combinations that do not allow repetitions (e.g. 123)
  2. 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 100+ Important Excel Functions

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