Question: how to count qty in excel?
Answer: Enter the sample data on your worksheet. In cell A7, enter a COUNTA formula, to count the numbers in column A: =COUNTA(A1:A5) Press the Enter key, to complete the formula. The result will be 4, the number of cells that contain data.