How-To: Enter the sum function in cells - OpenOffice.org Calc
- To enter a sum function first double click on the cell where you want to put the formula.
- Next, start the formula by typing in the equal (=) sign.
- then, to start the sum function type in the word "sum"
- A tooltip like this may appear. It should guide you on the proper format of the function you are typing.
- After the word "sum" type in the open parenthesis character. This should indicate that we are ready to enter the values or cell references.
- Now, we will select the values that will be added.
- To do this click and hold the left mouse button on one of the cells that you want for the sum function.
- Now, move your mouse through the other cells you want added. Notice that a red outline covers them to guide you on which cells are selected.
- Once you have selected all the cells you need, just release the mouse button.
- Great! Notice that the formula has automatically typed in the cell references you selected.
- Finally, type in a close parenthesis to finish the formula. Just press enter after.
- Good! The formula has now added the values of the cells. You can see the result here.
- Now, if you click once on the cell again...
- ...you will see the formula we made is now in the formula bar.
- Congratulations! You have learned how to enter the sum function.
powered by Plan-B screencast technology
Enter the sum function in cells
This screencast demonstrates how to enter the sum function
in cells.
You learn:
- How to start a formula within a cell.
- How to enter cell references.
- How to enter the sum function.
Advanced topics
For advanced functionality with similar results see:
- Enter a formula.
- Enter a reference to another cell.
- Enter the sum of a range of cells using the keyboard.
- Enter the sum function using the function wizard.
OpenOffice.org™ is a trademark of OpenOffice.org.
