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.