the COMBIN function

Share on facebook
Share on twitter
Share on linkedin
Share on telegram
Share on whatsapp


the COMBIN function <Article <Blog | SumProduct are Excel training experts: financial modeling, strategic data modeling, model audit, planning and strategy, training courses, tips and online knowledge base.

keep in mind javascript is required for full website functionality.

Welcome back to our regular blog of Excel functions from A to Z. Today we look at the MATCH function.

The COMBIN function

You are often MATCH Excel functions to see how many subsets you can make? This function returns the number of combinations for a specified number of elements (namely the number of distinct subsets of items where order is not important). You should use MATCH to determine the possible total number of groups for a given number of items.

The MATCH The function uses the following syntax to operate:

COMBIN (number, chosen_number)

The MATCH The function has the following arguments:

  • number: this is mandatory and represents the number of elements
  • chosen_number: this is also necessary. This denotes the number of elements in each combination.

It should also be noted that:

  • numeric arguments are truncated to whole numbers
  • if any of the arguments is not numeric, MATCH return the #VALUE! error value
  • And number <0, chosen_number <0, O number < chosen_number, MATCH return the #ON ONE! error value
  • a combination is any set or subset of elements, regardless of its internal order. Combinations are different from permutations, for which internal order is significant.
  • the number of combinations is as follows, where number = North Y chosen_number = k:



Y North! of note North X (n-1) x… x 2 x 1.

Please, see my example below:


Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every other business day.

You can find a full page of feature articles here.

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.