COUNTIF Function in Excel (Step by Step Tutorial) - How to Use COUNTIF Formula?

In this tutorial, we will learn how to use COUNTIF function in excel

𝐂𝐎𝐔𝐍𝐓𝐈𝐅 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
-------------------------------------------------

In Excel, COUNTIF is used to COUNTIF the number of cells within the specified range. It returns the integer number. This is an advanced version of COUNT; a built-in Excel function which counts the numeric values present in the given range of cells.

𝐅𝐨𝐫𝐦𝐮𝐥𝐚
---------------------------------------------

= COUNTIF (range, criteria)

𝐀𝐫𝐠𝐮𝐦𝐞𝐧𝐭𝐬
--------------------------

range = It is a required parameter. It represents the range of values to be applied to the criteria.

criteria = Another required parameter is the condition that will be applied to the values presented as the first parameter by the specified range.

𝐓𝐡𝐢𝐧𝐠𝐬 𝐭𝐨 𝐑𝐞𝐦𝐞𝐦𝐛𝐞𝐫
-----------------------------------------------------------------------------------------------------------

#1 - Double quotes must include non-numeric criteria. The numeric criteria do not need to be included in quotations.

#2 - Only the values that meet the given criteria will be returned.

#3 - The wildcard characters such as ‘*’ and ‘?’ can be used in the criteria.The question mark matches any character, and any sequence of characters matches the asterisk.