How to Use COUNT Function | Microsoft Excel
Count function will count only numerical values from the cell in the range given by you.
Count function will not count any non-numerical values.
Syntax of COUNT Function
Arguments of COUNT Function
value1: it is the range or reference of cells in which you have to count numerical values
value2: it is also reference or range of cells in which you have to count numerical values. a limit is 0 to 255 cells
Behavior of COUNT Function
- If any cell has a text value and converted to numerical than the count function counts the cell as a numerical value.
- If the cell contains alphanumerical values than count function will count the cell as the numerical value is present, For Example, “nirmal12” will count as a numerical value
- If any value has an error then it will not be counted For Example, “#VALUE” will not be counted