How to sum a column in excel

Use the SUM function in Excel to sum a range of cells, an entire column or non-contiguous cells.

How to sum multiple rows in excel

To create awesome SUM formulas, combine the SUM function with other Excel functions.

Sum a Range

Most of the time, you'll use the SUM function in Excel to sum a range of cells.

Note: simply type =SUM(A1:A8) to enter this formula.

When you arrive at: =SUM( instead of typing A1:A8, simply select the range A1:A8.

Sum an Entire Column

You can also use the SUM function in Excel to sum an entire column.

Note: you can also use the SUM function in Excel to sum an entire row.

For example, =SUM(5:5) sums all values in the 5th row.

Sum Non-contiguous Cells

You can also use the SUM function in Excel to sum non-contiguous cells. Non-contiguous means not next to each other.

Note: =A3+A5+A8 produces the exact same result!

AutoSum

Use AutoSum or press ALT + = to quickly sum a column or row of numbers.

1.

First, select the cell below the column of numbers (or next to the row of numbers) you want to sum.

2. On the Home tab, in the Editing group, click

how to total in excel sheet

how to add in excel sheet formula