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/