Friday, January 11, 2008

Formulas in Excel.

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.

No comments: