Question: how to get excel to count?
Answer: Enter the sample data on your worksheet.
In cell A7, enter an COUNT formula, to count the numbers in column A: =COUNT(A1:A5)
Press the Enter key, to complete the formula.
The result will be 3, the number of cells that contain numbers. Cell A1 isn't counted, because it contains text.