Skip to content
Excel

MULTINOMIAL function in Excel

Returns the multinomial of a set of numbers

=MULTINOMIAL(number1, [number2], ...)

MULTINOMIAL syntax and parameters

Two arguments, one required.

  • number1numberRequired
  • number2numberRepeating

MULTINOMIAL examples

Formulas you'll actually reuse.

  1. Ways to split 9 people into teams of 2, 3, and 4:

    =MULTINOMIAL(2, 3, 4)

    Result1260

  2. The same from a column of group sizes:

    =MULTINOMIAL(B2:B4)

    Result1260

MULTINOMIAL in Google Sheets

Same name — your formula ports as-is.

Try MULTINOMIAL in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Excel gets this done.