SUM Adds the numbers in the ranges.
The Sum function is explained pretty good here,, there is even a video for it.
SUM function is use to aggregate in MS Excel Suppose you want to sum values from A1 to A10 in A11, type = SUM(A1:A10)
If you want to find the sum of a column from A1 to A12, use the following formula: =SUM(A1:A12)If you ever want to add 2 or more values (numbers) in excel to get the result in a specified cell, you...
Excel assigns the SUM function when you highlight a range of cells and click the SUM button.
How to Sum Largest Values in an Excel Worksheet
How to Return all Columns Sum using Excel VLookup Function
Concatenate Vlookup Alternatives Tutorial