COMBINA Function in Excel – Return the number of combination with repetition

The COMBINA function in Excel calculates the number of combinations of a given number objects from the set with repetition.

For any 4 objects a,b,c,d there are 10 different combination of two objects

ab ac ad bc bd cd aa bb cc dd


Syntax of COMBINA Function in Excel

COMBINA(number,number_chosen)

 

number The number of objects in the set
number_chosen The number of objects to be chosen from the set

 

Example of COMBINA Function in Excel

Formula

COMBINA Function in Excel 1

  • In Row number 2, combination of two sets has to be chosen from 4 objects (a,b,c,d). and those sets are ab, ac, ad, bc, bd, cd, aa, bb, cc, and dd.

Similarly other combinations with repetition are calculated, so the result will be

Result

COMBINA Function in Excel 2

#NUM! Error occurs if the supplied number argument is negative.

#NUM! Error occurs if number_chosen Argument is greater than number argument.

previous COMBINA Function in Excel                                                                                                                next COMBINA Function in Excel