Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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.

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 .