SUM – How to Sum Values in Excel

In this article, we will discuss several ways to sum values in Excel. Or you can see this video.

Method 1: Using a regular formula

This method is suitable for small amounts of data. To sum two values, enter the following formula into a cell:

=A1+B1

Where A1 and B1 are the cells containing the values to be added.

To sum more than two values, you must enter the formula manually, listing each value in parentheses. For example, to sum the values in cells A1, A2, A3, and A4, enter the following formula:

=A1+A2+A3+A4

Method 2: Using the SUM function

This method is more convenient for summing large amounts of data. To do this, follow these steps:

1. Enter the SUM function into the cell where you want to display the result.
2. In the parentheses of the SUM function, specify the range of cells whose values you want to add.

For example, to sum the values in cells A1, A2, A3, and A4, enter the following formula:

=SUM(A1:A4)

Method 3: Using the AutoSum button

This method is the simplest and most convenient way to sum values in Excel. To do this, follow these steps:

1. Click on the cell where you want to display the result.
2. Click the AutoSum button on the ribbon.
3. Excel will automatically select the range of cells whose values you want to add.
4. Click Enter.

Summation of values using the CTRL key

If you want to sum values in multiple cells that are not consecutive, you can use the CTRL key. To do this, follow these steps:

1. Select the cells whose values you want to add.
2. Press the CTRL key.
3. Press the Enter key.

At this page you can find all of the functions in Excel.

For example, to sum the values in cells A1, B3, C5, and E10, follow these steps:

1. Press the CTRL key.
2. Select cells A1, B3, C5, and E10.
3. Press the Enter key.

Conclusion

In this article, we have discussed several ways to sum values in Excel. You can choose the most appropriate method for you depending on the amount of data and your needs.

Additional information

• The SUM function can also be used to sum values in a range of cells that are not consecutive. To do this, specify the range of cells in parentheses, separated by commas. For example, to sum the values in cells A1, B3, C5, and E10, enter the following formula:

=SUM(A1,B3,C5,E10)

• The AutoSum button will only automatically select a range of consecutive cells. If you want to sum values in a range of non-consecutive cells, you can use the CTRL key to select the cells manually.

I hope this is helpful!

Function – SUMDownload

Lesson information file