How to Use SUM Function in Excel

SUM


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 maximum number of arguments can be passed to the function is 255.

Argument: Any value that is given to the function and function uses that value for the calculation.

What to type in a cell of a 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 of the sum of the numbers. Numbers may be provided directly or by the cell references and ranges.


Examples:

Passing to the arguments as the numbers.


Passing to the arguments as the numbers and expression.


Passing to the arguments as the expression.


Passing to the arguments as the cell references. Values present in the passed cells are used by the function.


Passing to the arguments as the cell range. Values present in the passed cells range are used by the function.


Passing to the arguments as the cell references and range. Values present in the passed cells and ranges are used by the function.


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 a empty cell. The result does not have any effect on the result.

Thank you. Please share your feedback in the comments.

Leave a Reply