Totaling the values within a group of cells, columns, or rows is done using the SUM() function. It looks like this:
=SUM(A1,A2)
Here are some examples of how it can be used:
| A | B | C | |
| 1 | 1 | ||
| 2 | 2 | formula: | results: |
| 3 | 4 | =SUM(A1,A2) | 3 |
| 4 | 8 | =SUM(A2:A4) | 14 |
| 5 | =SUM(A:A) | 15 |
Summing Up a Selection
Follow the form given in cell B3 above to calculate a total of value in two or more individual cells. Select additional cells in formula B3 by placing clicking on them or entering them in separated by commas. E.g. =SUM(A2,A3,A4) = 14.
Summing Up a Range of Cells
Formula B4 shows how to calculate a sum on a group of cells. Additional arguments are also permitted here, separated by a comma, to do more complex summes. E.g.: =SUM(A1:A2,C4:C5) = 32.
Summing Up an Entire Column or Row
Calculating the sum of a column or row is done by passing the name of the column or row to the formula twice separated by the range indicator, like this: =SUM(A:A) = 15.
Tags: excel, function, microsoft office, Reference, sum