How To Add Numbers In A Column In Excel?

Click the cell where you want the total to appear

Type `=SUM(` and select the cells in the column you want to add

Close the formula with `)` and press Enter

Or click the AutoSum button on the Home tab

Select the range of numbers in the column

Press Enter to calculate the total

To add an entire column, use a formula like `=SUM(A:A)`

Suggested for You

Trending Today