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/
Comments