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:

Learn More:

How to setup AlchemyJ:​​ ​


How AlchemyJ works:

Let's connect: LinkedIn:

18 views0 comments