MULTINOMIAL Function
Returns the multinomial coefficient: (a+b+…)! ÷ (a! × b! × …).
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A whole number
Want to practice MULTINOMIAL in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
MULTINOMIAL counts the ways to split items into groups of given sizes.
For example, assigning 5 tasks so that Ana gets 2, Ben 2 and Cara 1: MULTINOMIAL(2, 2, 1) = 30.
Syntax
=MULTINOMIAL(number1, [number2], …)
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number1 | Yes | The first group size. |
| number2, … | Optional | More group sizes. |
Examples
Example 1 — Splitting tasks
Ways to assign tasks in these group sizes.
D2fx=MULTINOMIAL(A2:C2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Ana | Ben | Cara | Ways |
| 2 | 2 | 2 | 1 | 30 |
| 3 | 3 | 1 | 1 | 20 |
=MULTINOMIAL(A2:C2) Explain
Common mistakes
- Negative group sizes. Return #NUM!.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.