 |
Probably the most popular function in any spreadsheet is the SUM
function. The Sum function takes all of the values in each of the
specified cells and totals their values. The syntax is:
- =SUM(first value, second value, etc)
In the first and second spots you can enter any of the following (constant,
cell, range of cells).
- Blank cells will return a value of zero to be added to the total.
- Text cells can not be added to a number and will produce an error.
| Let's use the table here for the discussion that follows: We
will look at several different specific examples that show how the
typical function can be used! Notice that in A4 there is a TEXT
entry. This has NO numeric value and can not be included in a total. |
|
A |
| 1 |
25 |
| 2 |
50 |
| 3 |
75 |
| 4 |
test |
| 5 |
|
|
| Example | Cells to ADD | Answer |
| =sum (A1:A3) | A1, A2, A3 | 150 |
| =sum (A1:A3, 100) | A1, A2, A3 and
100 | 250 |
| =sum (A1+A4) | A1, A4 | #VALUE! |
| =sum (A1:A2, A5) | A1, A2, A5 | 75 |
1545711
info@exceltalk.net
|
