Counting of cells with numeric value:

It is very easy to count the cells with the numeric values.




In the above example, we have values in 10 cells, out of these 10 cells we have numeric values in 9 cells and the remaining one cell has a text value. We have used =COUNT(A1:A10) and calculated the count of the cells those are with the numeric values.