How to Use MULTINOMIAL in Google Sheets in 2020?

MULTINOMIALReturns the factorial of the sum of values divided by the product of the values’ factorials.

Sample Usage




MULTINOMIAL(value1, [value2, …])

value1 – The first value or range to consider.

value2, … – Additional values or ranges to consider.


Although MULTINOMIAL is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.

See Also

FACTDOUBLE: Returns the “double factorial” of a number.

FACT: The FACT function returns the factorial of a number.

COMBIN: The COMBIN function returns the number of ways to choose some number of objects from a pool of a given size of objects.