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.