How to sum filter data in excel

Use the SUM function in Excel to sum a range of cells, an entire column or non-contiguous cells. 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.

How to sum a column in excel

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 not sum negative numbers in excel

how to add non numeric values in excel