Use Excel COUNT Function to count cells which have numbers in it. In simple words, count function will only return the count of cells which have numbers & it will ignore all the other cell.
COUNT(value1, [value2], …)
- value1 A cell reference, an array or a number which is directly entered into the function.
- [value2] A cell reference, an array or a number which is directly entered into the function.
More Information on Excel COUNT Function
- You can specify up to 255 arguments.
- It can count numbers, dates & text which represent numbers.
- If you enter a logical value or text representation of a number directly into the function it will count them.
- Text & error values will be ignored by count function.
- If you specify a reference or an array, count function will only return the number of cells which have a numeric value.
- Empty cells will also ignore by count function.
In the below example, I have used count function to count cells from the range A1:A10 and it has return 8 in the result. In cell A3, we have a logical value and in cell A7 we have a text. Count function has ignored both of the cells.
But, if you enter a logical value directly into the function it will count it. In the below example, I have inserted a logical value and a number using double quotation marks.
Count Function has recognized both of the values and returned 2 in the result.
To learn more about Excel COUNT Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.