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

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

  1. Teams of 3 from 10 people

    ABCD
    1PeopleTeam
    2103120

    In D2: =COMBIN(A2, B2) → 120

    Try this example

  2. Different tickets in a 6-from-49 lottery

    ABCD
    1BallsDrawn
    249613,983,816

    In D2: =COMBIN(A2, B2) → 13,983,816

    One ticket has a 1 in 13,983,816 chance.

    Try this example

Common mistakes

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.

Translate a whole formula

Try COMBIN in the playground

Related functions