We have set of data as following.
4.4.1 COUNT Function
For COUNT function, it is use to count the number of cells that contain numbers. Type in the formula = COUNT (value1, value2, …)
4.4.2 COUNTA Function
For COUNTA function, it counts how many cells that is not empty. It has no restriction of type of data, either it is number, text or symbol. As long as it fills the cell, it will be counted as 1. To use the function, type in the formula = COUNTA (value1, value2, …)
4.4.3 COUNTBLANK Function
For COUNTBLANK function, as its names says, it will count cells that is blank and return the value of blank cell. To use the function, type in formula = COUNTBLANK (value1, value2, …)