Count Function in MS Excel 2013

How to count numbers in Ms Excel 2013?


Count function is used to count the number of cells that have only the numeric values. It ignores the text in the selected range of cell and count only the numerical values.
To use the count function, follow the steps given below.
Step 1: Type as "=Count" in the cell where you want to display the result.
count function ms excel 2013
Step 2: Open the parenthesis and select the range of cells, by clicking on the first cell and drag it to the extend you need.
count function1 ms excel 2013
Example, to find the numerical count from the range of cell A1 to A8 enter as =Count(A1:A8). Here the count function displays only the count of the cell that have numerical values.
count function output ms excel 2013

Related Topics