Skip to content
Google Sheets

MULTINOMIAL function in Google Sheets

Returns the factorial of the sum of values divided by the product of the values' factorials.

=MULTINOMIAL(value1, [value2, ...])

MULTINOMIAL syntax and parameters

Two arguments, one required.

  • value1anyRequired

    The first value or range to consider.

  • value2anyRepeating

    Additional values or ranges to consider.

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 Excel

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 Google Sheets gets this done.