Excel: COUNT Function

13: Excel COUNT Function

Purpose of COUNT function is to count number data and ignore text data. To count, choose a cell and enter the COUNT syntax: = COUNT (Range).The range is the cells of whom the counting needs to be done, for example cell A1:C6. If you enter any number data later in these cells, the counting cell will automatically update. So remember to keep the counting cell in a corner of the worksheet or away from the path of data rows and columns.

In the below screenshot, It’s only Counting Number of cell contain only Number, between B2 to B10.