How to Sum an Entire Column or a Row in Excel

In Excel, you can use the SUM function to sum values from an entire column, or a row. In this tutorial, we will look at all the methods that we can use for this.

Sum an Entire Column

As I said, you can use the SUM function to sum values from a column, and the following are the steps you need to follow:

  1. First, enter “=SUM” in the cell where you want to calculate the sum.
  2. Next, enter starting parentheses.
  3. After that, refer to the column for which you want to calculate the sum.
  4. In the end, enter closing parentheses and hit enter to get the result.
sum-an-entire-column

As you can see in the above example, we have used the sum function and referred to Column-A to get the sum for all the values from the column.

And if you want to sum up a row entirely, you need to refer to the row the way we have done in the following example.

sum-formula-to-sum-column

Sum Multiple Columns and Rows

There could be a situation where you need to sum values from multiple columns or rows, you need to use the method the way we have used in the following example.

For multiple columns:

sum-multiple-rows-and-columns

For multiple rows, row 1 and row 2.

sum-for-multiple-rows

Sum Non-Adjacent Columns or Rows

Now, in the following example, you have the sum function to sum multiple non-adjacent columns and rows. In the following example, you have the formula to sum columns A and C

sum-non-adjacent-columns-rows

And in this example, you have used the formula to sum non-adjacent rows.

sum-non-adjacent-rows-formula

In the above example, we have referred to rows 1, row 3, and row 5. So, if you want to.