COMBINA Function in Excel: Syntax, Examples and Free Practice
COMBINA is an Excel Statistical function. Returns the number of combinations, allowing repeats.
COMBINA syntax
=COMBINA(number, number_chosen)
Arguments
number: A number to use in the calculationnumber_chosen: How many items are chosen at a time
When to use COMBINA
COMBINA is used in data analysis work to summarize or test patterns across a data set.
Practice COMBINA online, free
Open the live Excel-style spreadsheet and try COMBINA yourself. No Excel install or sign-up needed to start.
Practice COMBINA now →More Statistical functions
Frequently asked questions
What does the COMBINA function do in Excel?
Returns the number of combinations, allowing repeats.
What is the syntax of COMBINA in Excel?
The syntax is =COMBINA(number, number_chosen). number: A number to use in the calculation; number_chosen: How many items are chosen at a time.
Where can I practice COMBINA online for free?
Open the free live spreadsheet on Cellgrids and try COMBINA yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts