How To Sum In Excel?

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

Use `=SUM(A1,A3,A5)` to add specific cells

Use `=A1+A2+A3` to add cells manually

Click the AutoSum button on the Home tab

Select the cells you want to total, then press `Alt` + `=` to insert AutoSum

Press `Enter` to calculate the sum

Include multiple ranges in one formula, such as `=SUM(A1:A5,C1:C5)`

Sum an entire column with `=SUM(A:A)`

Sum an entire row with `=SUM(1:1)`

Suggested for You

Trending Today