![]() |
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Excel > Functions > Maths and Trigonometry > SUM |
SUM(number1, number2 [,number3] [,...]) |
| Returns the sum of a list of numbers. |
| number1 | The first number. | |
| number2 | The second number. | |
| number3 | (Optional) The third optional number. |
| REMARKS |
| This function includes hidden rows. | ||
| The number arguments can be values, cell references, named ranges or even other functions. | ||
| Empty cells, logical values, text, or error values in the array or reference are ignored. | ||
| If an argument is a cell reference, only numbers are counted. | ||
| Numbers can also be logical values as well as text. | ||
| If an argument is an array then #VALUE! is returned. | ||
| You can include non-continuous cell ranges but separating them with a comma. | ||
| There is also an AutoSum button located on the standard toolbar to help you enter this function quickly. | ||
| It is possible to add up all the values in a particular column. To sum all the values in column "C" use: "=SUM(C:C)". | ||
| You can have a maximum of 30 arguments. | ||
| Example 1 - | ||
| Example 2 - | ||
| Example 3 - | ||
| Example 4 - | ||
| Example 5 - | ||
| Example 6 - | ||
| Example 7 - | ||
| Example 8 - | ||
| Example 9 - | ||
| Example 10 - | ||
| Example 11 - | ||
| Example 12 - | ||
| Example 13 - | ||
| Example 14 - | ||
| Example 15 - Array Formula. | ||
| Example 16 - | ||
| Example 17 - Array Formula. What is the sum of the squares of the numbers {1,2,3,4}. | ||
| Example 18 - | ||
| Example 19 - | ||
| Example 20 - |
| EXAMPLES |
|
| Functions - S | Index - S | Office Online 2003 | Office Online 2007 |
| Copyright © 2010 Better Solutions Limited. All Rights Reserved. | Top |