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

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

  1. Three scoops from four flavours

    ABCD
    1FlavoursScoops
    24320

    In D2: =COMBINA(A2, B2) → 20

    Try this example

  2. Without repeats it would be 4

    ABCD
    1FlavoursScoops
    24316

    In D2: =COMBINA(A2, B2)-COMBIN(A2, B2) → 16

    Try this example

Common mistakes

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.

Translate a whole formula

Try COMBINA in the playground

Related functions