Question: how to add qty in excel?
Answer: Ways to add values in a spreadsheet. One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum.