Skip to content
ExcelExcel 2013+

COMBINA function in Excel

Returns the number of combinations with repetitions for a given number of items

=COMBINA(number, number_chosen)

COMBINA syntax and parameters

Two arguments, two required.

  • numbernumberRequired

    Must be greater than or equal to 0, and greater than or equal to Number_chosen. Non-integer values are truncated.

  • number_chosennumberRequired

    Must be greater than or equal to 0. Non-integer values are truncated.

COMBINA examples

Formulas you'll actually reuse.

  1. Ways to pick 3 scoops from B2 flavours, repeats allowed:

    =COMBINA(B2, 3)

    Result56

  2. Distinct results of rolling two dice when order doesn't matter:

    =COMBINA(6, 2)

    Result21

COMBINA in Google Sheets

Same name — your formula ports as-is.

Try COMBINA in the playground

Edit the example — nothing to install.

Preloaded with the COMBINA formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.