There are different ways of counting values, and Excel offers several ways of counting, including certain criteria. This works by inputting a function, such as =COUNT, and selecting a range of cells.
- COUNT counts the number of cells in the selected cell range that contain numbers.
- COUNTA counts the number of cells in the selected cell range that are not empty.
- COUNTIF counts the number of cells that meet specific criteria, for example, =COUNTIF(A2>A3)
- COUNTBLANK counts the number of cells that are blank.
Example
We’d like to know how many cells in this range are blank, so we will first input =COUNTBLANK
Then, we will select the range of cells:
Here, we can see that there are three empty cells in this range:
