# Sum an Entire Column or a Row

HomeExcel FormulasSum an Entire Column or a Row

Table of Content

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.

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 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:

For multiple rows, row 1 and row 2.

## 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

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

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

📂 sample-file.xlsx