Basic Excel Function - How to use COUNTIFS Function in Excel


A COUNTIFS function "Counts the number of cells specified by a given set of conditions of criteria". As for today's tutorial, we will find the number of females equal or older than 30 years old and have a higher IQ of 100.


I will also be using AlchemyJ Studio Excel Add-in to turn this COUNTIFS Function Excel into an API.


Time Stamps:

"​​​00:00​": Intro

"​​​00:32": How to use COUNTIFS Function for 2 Criteria

"01:06​​​​": How to use COUNTIFS Function for 3 Criteria

"01:56​": Convert COUNTIFS function into Application Programming Interface (API)


Download:

AlchemyJ FREE Community Edition: https://www.alchemyj.io/download


Learn More:

How to setup AlchemyJ: https://www.youtube.com/watch?v=eTyYTf1sw9k&feature=youtu.be&ab_channel=AlchemyJ​​​


How AlchemyJ works: https://www.youtube.com/watch?v=bAQHo8I1xuQ&ab_channel=AlchemyJ


Let's connect: LinkedIn: https://www.linkedin.com/company/alchemyj/

29 views0 comments