COMBINA

Formulas / COMBINA
Count combinations with repetitions allowed.
COMBINA(number, number_chosen)
  • number - required, must be greater than 0 and greater than or equal to number_chosen
  • number_chosen - required, must not be less than 0

Examples

  • =COMBINA(10,3) returns 220

    In this example, the COMBINA function is used to calculate the number of possible combinations from a set of 10 items taken 3 at a time. The result is 220, because there are 220 distinct combinations of 3 items that can be taken from the set of 10.

  • =COMBINA(B6,C6)

    In this example, the COMBINA function is used to calculate the number of possible combinations from a set of items in column B. The number of items to be chosen is specified in the corresponding cell in column C. For example, if cell B6 contains the set {A, B, C, D} and cell C6 contains the number 2, the result of the COMBINA function will be 6, since there are 6 combinations of 2 items that can be taken from the set {A, B, C, D}.

Summary

The COMBINA function is used to calculate the number of combinations of items. It requires two arguments, number and number_chosen, which must be greater than or equal to 0.

  • The COMBINA function requires two arguments: number and number_chosen.
  • The number argument is the total number of items and the number_chosen argument is the number of items in each combination.
  • The COMBINA function returns the number of combinations with repetitions allowed in a given set. To count combinations that do not have repetitions use COMBIN.

Frequently Asked Questions

What is the COMBINA function?
The COMBINA function is a Sourcetable formula that helps count how many combinations there are with repetitions.
What errors may occur when using the COMBINA function?
The COMBINA function may return an error if either of the arguments do not meet the function's constraints. If either argument is outside the constraints, a #NUM! error is returned. If either argument is a non-number, a #VALUE! error is returned.
How can I prevent errors when using the COMBINA function?
  • Make sure both arguments meet the constraints of the COMBINA formula.
  • Ensure both arguments are numbers, not text or blank values.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.