Excel functions / Math
COMBINA function
The number of ways to choose items when the same item may be chosen more than once and the order does not matter.
Syntax
=COMBINA(number, number_chosen)
Arguments
number: How many different items there are.number_chosen: How many are chosen.
When to use it
COMBINA counts the ways to choose items when the same item may be chosen more than once and the order does not matter: three scoops from four flavours, with doubles allowed.
Examples
Three scoops from four flavours
A B C D 1 Flavours Scoops 2 4 3 20 In D2:
=COMBINA(A2, B2)→ 20Without repeats it would be 4
A B C D 1 Flavours Scoops 2 4 3 16 In D2:
=COMBINA(A2, B2)-COMBIN(A2, B2)→ 16
Common mistakes
- Order mattering. COMBINA ignores order. With order and repeats, use PERMUTATIONA.
COMBINA in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: COMBINA
- Danish: KOMBINA
- Dutch: COMBIN.A
- Finnish: KOMBINAATIOA
- French: COMBINA
- German: KOMBINATIONEN2
- Hungarian: KOMBINÁCIÓK.ISM
- Italian: COMBINAZIONE.VALORI
- Norwegian: KOMBINASJONA
- Polish: KOMBINACJE.A
- Portuguese (Brazil): COMBINA
- Portuguese (Portugal): COMBIN.R
- Russian: ЧИСЛКОМБА
- Spanish: COMBINA
- Swedish: KOMBINA
- Turkish: KOMBİNASYONA
Related functions
- COMBIN: How many ways to choose a number of items from a group, when the order does not matter.
- PERMUTATIONA: The number of ordered arrangements when the same item may be used more than once: number to the power of number_chosen.