Question: how to calculate qty in excel?
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.