Suppose that you want to add 3 cells from your worksheet together. For the sake of argument, let's say these cells are A1, A2, and A3. First, choose a 4th cell, say A4, for which you want the sum to appear in. Now, do the following:
- On the chosen 4th cell, type in: =A1+
- Move the arrow keys to the 2nd cell (A2).
- Type in: +
(You should then see "=A1+A2+").- Move the arrow keys to the 3rd cell (A3).
- Hit [Enter].
(You should then see "=A1+A2+A3").Alternatively, you may perform multiple additions by using the Autosum button. This is invoked by clicking the
symbol found on the Toolbar, where you have previously highlighted the cells that contain data you want to sum together.
You can perform the following operations using the first technique mentioned above:
+ = Addition - = Subtraction * = Multiplication / = Division