Excel Tutorial
- In this tutorial, you will learn how to count cells in excel using various count() functions
- You can use 4 different count functions to count the total number of cells in excel. They are
- count(range)
- countA(range)
- countBlank(range)
- countIf(range, condition)
1. Using count(range)
- It is a predefined excel function which is used to count the total number of cells which contains only numbers
- It returns the integer value.
Syntax
=count(range)
Where,
range is a group of input cells.
Example 1
Input Data
Applying count() function
Result
2. Using countA(range)
- It is another predefined excel function which is used to count the total number of cells which contains text, numbers, special characters, etc,.
- It returns the integer value.
Syntax
=countA(range)
Where,
range is a group of input cells.
Example 2
Input Data
Applying count() function
Result
3. Using countBlank(range)
- It is a built-in excel function which is used to count the total number of cells which contains only empty cells
- It returns the integer value.
Syntax
=countBlank(range)
Where,
range is a group of input cells.
Example 3
Input Data
Applying countBlank() function
Result
4. Using countIf(range, criteria)
- It is a predefined excel function which is used to count the total number of cells based only on the condition
- It returns the integer value.
Syntax
=countIf(range, condition)
Where,
range is a group of input cells.
Example 4
Input Data
Applying countIf() function
- Here, word frequency is calculated using countif() function.
- The word hi is counted as 3.
Result
