COMBIN Function
Returns the number of ways to choose items from a group, ignoring order.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A whole number
Want to practice COMBIN 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
COMBIN(n, k) counts the groups of k you can pick from n items when order doesn't matter: a team of 3 from 10 people is COMBIN(10, 3) = 120.
Use PERMUT when order matters, and COMBINA when items can repeat.
Syntax
=COMBIN(number, number_chosen) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | How many items there are. |
| number_chosen | Yes | How many are chosen each time. |
Examples
Example 1 — Possible project teams
How many different 3-person teams can Northstar form?
C2fx=COMBIN(A2, B2)
| A | B | C | |
|---|---|---|---|
| 1 | Staff | Team size | Teams |
| 2 | 10 | 3 | 120 |
| 3 | 6 | 2 | 15 |
| 4 | 12 | 4 | 495 |
=COMBIN(A2, B2) Explain
Common mistakes
- Chosen larger than the group. Returns #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.