1. Technology
Send to a Friend via Email

Your suggestion is on its way!

An email with a link to:


was emailed to:

Thanks for sharing About.com with others!

You can opt-out at any time. Please refer to our privacy policy for contact information.



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.

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.