Basic Excel Function - How to use COUNTIF Function in Excel
A COUNTIF function “counts the number of cells within a range that meet the given condition”. The COUNTIF function can count both texts and number. I will be turning COUNTIF function into an API. Let's see how the magic works.
Time Stamps:
"00:00": Intro
"00:28": Basic COUNTIF Text Example
"00:51": Advance COUNTIF Text Example
"01:20": Basic COUNTIF Number Example
"01:47": Advance COUNTIF Number Example
"02:41": Convert COUNTIF 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/