How to use SUM function in Microsoft excel?

About Function:

The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments.

Purpose of the Function:

Add numbers together

Output Value:

The sum of values supplied

Syntax:

=SUM(number1, [number2], …)

Arguments:

number1 – first value.

number2 – [Optional] second value.

Example:

Range	=SUM(D7:D10)	returns 22
Reference	=SUM(D7,D9)	returns 14
Constant	=SUM(5,10,15)	returns 30

Other Relevant Posts:

• How to use COUNT function in Microsoft excel?
• How to use IF function in Microsoft excel?
• Simple Project Management Dashboard using Microsoft excel
• Calculator using VBA in Microsoft Excel