How to Add in Excel - SUM Formula

How to Add in Excel - SUM Formula

To use the SUM formula in Excel, follow these steps:

Start by selecting the cells that you want to add together. You can select multiple cells by clicking and dragging your mouse, or by holding down the "Shift" key and using the arrow keys on your keyboard to select a range of cells.

Once you have selected the cells that you want to add, type "=SUM(" (without the quotes) into the formula bar at the top of the screen. This will tell Excel that you want to use the SUM formula to add the selected cells together.

After typing the "=SUM(" part of the formula, use your mouse to click on the first cell that you want to add. This will add the cell reference to the formula.

Next, type a comma (,) to separate the first cell reference from the next one. Then use your mouse to click on the next cell that you want to add. Repeat this process for each cell that you want to include in the sum.

Once you have added all of the cell references to the formula, type a closing parenthesis ")" at the end of the formula to complete it.

Finally, press "Enter" on your keyboard to calculate the sum of the selected cells. The result will be displayed in the cell where you entered the formula.

Here is an example of a SUM formula that adds together the values in cells A1, A2, and A3:

Copy code

=SUM(A1, A2, A3)

When you press "Enter" on your keyboard, the formula will calculate

··

And if this article about How to Add in Excel - SUM Formula hasn't satisfied you yet, you can watch the video below.

That's all from SmashinGeeks, see you in another article. ^^