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
Excel Template: https://www.alchemyj.io/aj-excel-temp...
Learn More:
How to setup AlchemyJ: • How to install AlchemyJ
How AlchemyJ works: • How AlchemyJ Works
Website: https://www.alchemyj.io/
Let's connect: LinkedIn: / alchemyj
On this page of the site you can watch the video online Basic Excel Function - How to use COUNTIFS Function in Excel with a duration of hours minute second in good quality, which was uploaded by the user AlchemyJ 05 May 2021, share the link with friends and acquaintances, this video has already been watched 66 times on youtube and it was liked by 2 viewers. Enjoy your viewing!
