COMBIN

Returns the number of ways to choose some number of objects from a pool of a given size of objects. Learn more

Video field
Math

In Google Sheets, COMBIN is a function that calculates the number of combinations of k items that can be selected from a set of n items, without regard to order. The function takes two arguments:

n: This is the total number of items in the set. k: This is the number of items to select from the set.

The COMBIN function returns the number of possible combinations of k items that can be selected from the set of n items. The formula for the function is:

=COMBIN(n, k)

For example, if you have a set of 10 items and you want to know how many combinations of 3 items can be selected from the set, you can use the COMBIN function like this:

=COMBIN(10, 3)

The resulting number would be 120, which is the number of possible combinations of 3 items that can be selected from a set of 10 items.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!