How to Add to Columns in Excel?

Click the cell where you want the total to appear

Type =SUM(

Select the cells in the column you want to add

Type )

Press Enter

Use AutoSum by selecting the total cell and clicking AutoSum on the Home tab

Drag the fill handle down to copy the formula to other rows if needed

Use =A1+B1+B2 for adding specific cells in a column

Use =SUM(A:A) to add an entire column

Use =SUM(A1:A10) to add a range of cells in a column

Suggested for You

Trending Today