How To Add Up Cells In Excel?

Select the cell where you want the total to appear

Type `=SUM(`

Select the range of cells you want to add

Type `)`

Press `Enter`

Example: `=SUM(A1:A10)`

To add non-adjacent cells, type `=SUM(A1,B1,C1)`

To add cells manually, type `=A1+B1+C1`

Use AutoSum by selecting the total cell and pressing `Alt` + `=`

Drag to select a range of cells and press `Enter` after AutoSum inserts the formula

Suggested for You

Trending Today