COUNT
Excel COUNT Function
Excel has a built-in function called COUNT that counts cells containing numbers inside a specified range.
The typeface is =COUNT.
Note: Only cells with numbers are counted by the COUNT function; cells with letters are not. If there are letters in the cells, the =COUNTA function works better.
How to use the =COUNT function:
- Select a cell
- Type =COUNT
- Double click the COUNT command
- Select a range
- Hit enter
Here are a few illustrations!
Utilize the =COUNT function on the D2:D21 range. Calculating the total number of cells in the Pokemon stats:
COUNT function, step by step:
- Select D23
- Type =COUNT
- Double click COUNT in the menu
- Select range D2:D21
- Hit enter
Note : that only cells with numbers in a range are counted by the =COUNT function.
And that’s it! Twenty cells with numbers were successfully tallied by the =COUNT function.
A Non-Working Example
Let’s try an ineffective example now.
Utilizing the range A2:A21, which consists solely of lettered cells, apply the =COUNT function.
It gives the result 0, no numeric cells were identified. There were just lettered cells in range A2:A21.
