COMBINA function
COMBINA counts combinations like COMBIN but allows repeats, such as the possible 2-scoop orders from 3 ice-cream flavors. Use COMBIN if each item can only be used once.
Example
Read it as a sentence: count the ways to choose 2 items, with repeats allowed, from the number in each cell of A1:A3, which starts with 1.
Excel shows 1
A
1
1
2
2
3
3
Data
Syntax
COMBINA(number, number_chosen)
-
number(required) - The number of distinct items available.
-
number_chosen(required) - How many picks you make.
Returns: The number of combinations when an item may be picked more than once.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=COMBINA(4,3) | 20 | 4,3 |
=COMBINA(0,0) | 1 | 0,0 |
=COMBINA(2,5) | 6 | 2,5 chosen > number ok |
=COMBINA(4.9,3.9) | 20 | Non-integers |
=COMBINA("4","3") | 20 | Text number |
=COMBINA(Data!A1:A3,2) | 1 | Spill |
=COMBINA(0,1) | #NUM! | 0,1 |
=COMBINA(-1,1) | #NUM! | Negative |
The Data sheet these formulas read
A cell that starts with = holds that formula.
A
1
1
2
2
3
3
Data
Watch out for
- Use COMBIN if each item can only be used once.
Where it works
- Excel
- COMBINA arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .