COUNTIF Function

---

Purpose of the Function

The Excel COUNTIF Function, It Is Use for Count the Number of Cells That Meet A Criterion.

Syntax

• range: The range of cells that you want to evaluate against the given criteria.
• criteria: The condition or criteria used to determine which cells to count.

Practical Example

Step -01 : Call COUNTIF Function :

Select The Cell, Which You Want to Apply The Function And Write COUNTIF Function =COUNTIF In Selected Cell.

---

Step -02 : Enter COUNTIF Arguments :

We need to select The Cells Which We Want to Returns the Count with single condition. Here is More than 90 Student Mark in the MARK1 therefore, we have to select the range From B2 to B10 Cells with in the Brackets.

---

Step -03 : Hit The Enter Key :

After Entering the Function, we need hit The Enter Key, The Excel Retrieve the Count Value Which We Selected Cells or Range. In this Example One Values are More than 90

---

• Previous
• Next

Advance Excel 365

---

Introduction to Microsoft Excel

---

• What is Excel 365
• Microsoft Excel
• Microsoft Excel Formulas and Functions

Mathematical Functions

---

• SUM Function
• AVERAGE Function
• MAX Function
• MIN Function
• ROUND Function
• SUMIF Function
• COUNT Function
• COUNTA Function
• COUNTIF Function

Date And Time Functions

---

• NOW Function
• TODAY Function
• YEAR Function
• MONTH Function
• DAY Function
• HOUR Function
• MINUTE Function
• SECOND Function
• TIME Function

Text Functions

---

• CONCATENATE Functions
• LEN and MID Function
• TRIM Function
• TEXT Function
• LEFT Function
• RIGHT Function
• UPPER Function
• LOWER Function
• PROPER Function
• REPT Function
• EXACT Function

Logical Functions

---

• IF Function
• VLOOKUP Function