Question: what is the formula in excel to add a column?
Answer: To sum a column of numbers, select the cell immediately below the last number in the column. ... 
AutoSum is in two locations: Home > AutoSum, and Formulas > AutoSum.
Once you create a formula, you can copy it to other cells instead of typing it over and over. ... 
You can also use AutoSum on more than one cell at a time.