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

ArgumentRequired?What it does
numberYesHow many items there are.
number_chosenYesHow many are chosen each time.

Examples

Example 1 — Possible project teams

How many different 3-person teams can Northstar form?

C2fx=COMBIN(A2, B2)
ABC
1StaffTeam sizeTeams
2103120
36215
4124495
=COMBIN(A2, B2) Explain

Common mistakes

  • Chosen larger than the group. Returns #NUM!.

Notes

Kyle Stott

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.