1. Computing

Function

By

Excel SUM Function

Excel SUM Function

© Ted French
Definition: A function is a preset formula in Excel. Like formulas, functions begin with the equal sign ( = ) followed by the function's name and its arguments. The function name tells Excel what calculation to perform. The arguments are contained inside round brackets.

For example, the most used function in Excel is the SUM function, which is used to add together the data in selected cells. The SUM function is written as -

= SUM ( D1 : D6 )

Here the function adds the contents of cell range D1 to D6 and displays the answer in cell D7.

Examples:
Before adding the function to the spreadsheet, it is a good idea to enter the data that it will use as its arguments first. This way the cell references of the data will be correct when entered into the function.

©2014 About.com. All rights reserved.