COMBINA Function

Returns the number of combinations when items can be chosen more than once.

Category

Math & Trig

Available in

Excel 2013+, Microsoft 365

Returns

A whole number

Want to practice COMBINA 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

COMBINA counts combinations with repetition: picking 2 scoops from 3 flavours where two of the same is allowed gives COMBINA(3, 2) = 6.

Order still doesn't matter.

Syntax

=COMBINA(number, number_chosen) Explain

Arguments

ArgumentRequired?What it does
numberYesHow many kinds of item.
number_chosenYesHow many are chosen.

Examples

Example 1 — Product bundles

Bundles of k items from n products, repeats allowed.

C2fx=COMBINA(A2, B2)
ABC
1ProductsPer bundleBundles
2326
34320
45215
=COMBINA(A2, B2) Explain

Common mistakes

  • Confusing with COMBIN. COMBIN(3, 2) is 3 (no repeats); COMBINA(3, 2) is 6.

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.