COUNT Function

---

Purpose of the Function

The Excel COUNT function returns the count of values that are numbers, generally cells that contain numbers.

Syntax

• value1, [value2], ...: These are the values or cell references you want to count. You can input up to 255 arguments.

Practical Example

Step -01 : Call COUNT Function :

Select the Cell, Which You Want to Apply the Function and Write COUNT Function =COUNT in Selected Cell

---

Step -02 : Enter COUNT Arguments :

We need to select The Cells Which We Want to Returns the Count Numbers with in the Brackets. In this example we need to count from B2 to B10 cells.

---

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.

---

• 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