In this post, you will learn how to use SUM Function in Excel.
How to Use SUM Function in Excel?
What does the SUM function do?
It gives the sum of the numbers passed to the functions.
There should be at least one argument passed to the function and the maximum number of arguments that can be passed to the function is 255.
Argument: Any value given to the function and the function uses that value for the calculation.
What to type in a cell of an Excel sheet?
Allowed arguments – Numbers, cell references, cell ranges, or combinations of these.
=SUM(Number 1, …Number 255) OR
=SUM(Cell references) OR
=SUM(Cell Ranges) OR
=SUM(numbers, cell references, range)
When to use this function?
When we need the sum of the numbers. Numbers may be provided directly or by cell references and ranges.
Examples:
Passing to the arguments as the numbers.
Passing to the arguments as the numbers and expressions.
Passing to the arguments as the expression.
Passing to the arguments as the cell references. The function uses values present in the passed cells.
Passing to the arguments as the cell range. The function uses values present in the passed cell range.
Passing to the arguments as the cell references and range. The function uses values present in the passed cells and ranges.
Combination of range, cell reference, and number.
Combination of range, cell reference, number, and empty space. It does not have any effect on the result.
Passing the cell range with a number present in a cell of the range.
Passing the cell range with an empty cell. The result does not have any effect on the result.