Sum Function
Sum function is used to create total from a list of numbers. The list can be a cell reference, a range, a positive or negative constant value, a formula, an array, even a Boolean text (when calculate, True will be translated into number 1 and False will be translated into number 0) or all together.
Syntax
=SUM(Number1,Number2,...Number255)
- Number1 - required
- Number2 to Number255 - optional
- If input number has error, then excel displays an error value
Shortcut
Alt+= (press Alt key then equal key)
When this shortcut is used, excel consider the adjacent ranges either in horizontally or vertically
Tips when Drag with Mouse
Adjust Range
When you click the cell where SUM formula is entered, excel automatically highlights the ranges which included in SUM formula. By dragging in or out, you can change the SUM formula ranges.
Copy to other cells
SUM formula can be easily copied to other cells either by dragging or copy-paste command.
- When you drag or copy-paste SUM formula to other cells, the range value will be automatically adjusted by excel with respective to the cell where you drag. But, if '$' is included in front of row number or column letter, then the range value will not be altered. You can understand this, in the Example section. This is a useful trick.
