Practice free

COMBIN function

COMBIN counts combinations, for example how many 3-person teams can be formed from 8 people. Order does not matter and items are not repeated, and decimals in the inputs are truncated.

Example

Read it as a sentence: count the ways to choose 3 items from 8 when order does not matter, which gives 56.

Practice this in the app

Syntax

COMBIN(number, number_chosen)

number (required)
The size of the full set.
number_chosen (required)
How many items you pick each time.

Returns: The number of different groups possible, ignoring order and without repeats.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=COMBIN(5,2) 10 5,2
=COMBIN(5,0) 1 5,0
=COMBIN(5,5) 1 5,5
=COMBIN(5.9,2.9) 10 Non-integers 5.9,2.9
=COMBIN(0,0) 1 0,0
=COMBIN("5","2") 10 Text number
=COMBIN(2,5) #NUM! 2,5 chosen > number
=COMBIN(-1,1) #NUM! Negative

Watch out for

  • Decimals are truncated.
  • number_chosen larger than number returns #NUM!.

Where it works

Excel
COMBIN is in every version of Excel from 2007 on.
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 .