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)


AlchemyJ FREE Community Edition:

Learn More:

How to setup AlchemyJ:​​​

How AlchemyJ works:

Let's connect: LinkedIn:

29 views0 comments