How To Sum Columns In Excel?

Select the cell where you want the total

Type `=SUM(`

Select the range of cells in the column

Type `)`

Press Enter

Or click the AutoSum button on the Home tab

Or use `=SUM(A1:A10)` to sum a column range

Copy the formula down or across if needed