What is COMBINA Function in Excel?
The COMBINA function is one of the math functions of Excel.
It Returns the number of combinations with repetitions for a given number of items.
We can find this function in Math & trig category of insert function Tab.
How to use COMBINA function in excel
- Click on an empty cell (like F5 )

2. Click on fx icon (or press shift+F3)

3. In the insert function tab you will see all functions

4. Select math and trig category
5. Select COMBINA function
6. Then select ok

7. In the function arguments Tab you will see COMBINA function
8. Number is the total number of items
9. Number_chosen is the number of items in each combination
10. You will see results in the formula result section

Examples of COMBINA function in Excel
Example 1:
How to use COMBINA function in excel
You can see examples of COMBINA function below:

combina(A2,B2) ----->>>>answer is 5
combina(A3,B3) ----->>>>answer is 15
combina(A4,B4) ----->>>>answer is 35
combina(A5,B5) ----->>>>answer is 70
combina(A6,B6) ----->>>>answer is 126
What is the purpose of COMBINA function?
It Returns the number of combinations with repetitions for a given number of items.
What is the Return value of COMBINA function?
It returns a number.
How many arguments does COMBINA function have?
This function has just 1 Argument.
The argument of COMBINA function is number.
Number is the total number of items.
Number_chosen is the number of items in each combination.
The argument of COMBINA function is required and not optional.
COMBINA(number) = number
Which version of excel supports COMBINA function?
This function is available for all excel versions (2003-2019)
Errors in COMBINA function
COMBINA related functions :
- COMBIN function
- PERMUT function
- PERMUTATIONA function