COMBIN Function in Excel: How Many Groups Are Possible

⏱ 1 min readUpdated 28 September 2026

MathLevel: IntermediateAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Related functions

COMBIN counts the ways to choose items when order doesn’t matter — teams from a class, lottery tickets, product bundles.

Syntax

=COMBIN(number, number_chosen)
Argument What it means
number Total items.
number_chosen Items in each group.

Examples

Example 1

=COMBIN(11, 5)

462 different five-a-side teams from 11 players.

PERMUT · FACT

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZFLOOR.MATH Function in Excel: Round Down to a MultipleExcel Functions A–ZCHISQ.TEST Function in Excel: Are These Categories Related?Excel Functions A–ZINTRATE Function in Excel: Interest Rate of a Fully Invested Security
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong