Excel functions / Math
COMBIN function
How many ways to choose a number of items from a group, when the order does not matter.
Syntax
=COMBIN(number, number_chosen)
Arguments
number: How many items there are.number_chosen: How many are chosen.
When to use it
COMBIN counts the ways to choose a number of items from a group when the order does not matter: how many different teams, hands of cards or lottery tickets there are. When the order matters, use PERMUT.
Examples
Teams of 3 from 10 people
A B C D 1 People Team 2 10 3 120 In D2:
=COMBIN(A2, B2)→ 120Different tickets in a 6-from-49 lottery
A B C D 1 Balls Drawn 2 49 6 13,983,816 In D2:
=COMBIN(A2, B2)→ 13,983,816One ticket has a 1 in 13,983,816 chance.
Common mistakes
- When order matters. A first, second and third prize is a different result from the same three people in another order. That is PERMUT, which counts more.
COMBIN 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: KOMBINACE
- Danish: KOMBIN
- Dutch: COMBINATIES
- Finnish: KOMBINAATIO
- French: COMBIN
- German: KOMBINATIONEN
- Hungarian: KOMBINÁCIÓK
- Italian: COMBINAZIONE
- Norwegian: KOMBINASJON
- Polish: KOMBINACJE
- Portuguese (Brazil): COMBIN
- Portuguese (Portugal): COMBIN
- Russian: ЧИСЛКОМБ
- Spanish: COMBINAT
- Swedish: KOMBIN
- Turkish: KOMBİNASYON
Related functions
- PERMUT: How many ways to pick a number of items from a group, when the order matters.
- COMBINA: The number of ways to choose items when the same item may be chosen more than once and the order does not matter.
- FACT: Factorial: 1 × 2 × … × n.
- BINOM.DIST: The chance of a number of successes in a set number of tries, each with the same chance.