Excel provides 4 different functions to count cells: count(), counta(), countblank(), countif()
=count(A1:A10)Counts cells in the range which hold a value. Empty cells and cells containing formulas are not counted.
=counta(A1:A10)Counts non-empty cells in the range. Cells containing formulas are counted.
=countblank(A1,A10)Counts empty cells in the range.
=countif(A1:A10,”<10″)Counts cells in the range which satisfy a condition. In this example, only cells with value less than 10 are counted.