top of page

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/

21 views
bottom of page