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], …)
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.