An Overview of SUM Function | Microsoft Excel

The SUM function is one of the math and trigonometry functions in Microsoft Excel. It can be used as a standalone function as well as in collaboration with the other functions. This article will give you an overview of the SUM function in Excel.

Objectives

The SUM function returns the summation of the given values inside the function. It accepts numbers, ranges, cell references, or a combination of any of the three.

Syntax

=SUM(number1,[number2],...)

Arguments

  • number1: Compulsory. It refers to the first number to calculate the summation. It can be a numerical value (5), a range (B5:B10), a single cell reference (B5), etc.
  • number2: Non-compulsory. It refers to the second number to calculate the summation. The SUM function supports up to 255 numbers.

Output

A numerical value.

Examples of SUM Function

Suppose, you want to calculate the summation of two numbers 4 and 5. The number 4 is in cell A1 and 5 is in cell A2. Now you can use the SUM function to calculate the summation of these two numbers. Just use any one of the following formulas.

=SUM(4,5)
=SUM(A1,A2)
=SUM(A1:A2)

Now here are more examples of the SUM function. Take a look.

Examples of SUM Function in Excel

Usage Guide of SUM Function

Step_1: Start with inserting an equal sign (=) in a blank cell.

Step_2: Then type SUM.

Step_3: Type open parenthesis “(“.

As you type the open parenthesis, Excel shows the syntax of the SUM function.

Step_4: Insert the first number to add.

You can directly insert a number, a cell address, or a range.

Step_5: Then insert a comma (,).

After inserting the comma, Excel will ask you for the second argument which is the second number to calculate the summation.

Step_6: Now insert the second number to add.

This way you can insert up to 255 numbers.

Step_7: Finally, add a closing parenthesis “)” to complete the syntax.

Step_8: Now, press ENTER.

The SUM function will return a numerical value which is the summation of the given numbers.

Availability

  • Excel for Microsoft 365
  • Excel 2016
  • Excel for Microsoft 365 for Mac
  • Excel 2016 for Mac
  • Excel for the web
  • Excel 2013
  • Excel 2021
  • Excel 2010
  • Excel 2021 for Mac
  • Excel 2007
  • Excel 2019
  • Excel for Mac 2011
  • Excel 2019 for Mac
  • Excel Starter 2010

Remarks

  • The SUM function can sum up a range of cells that meet certain criteria.
  • It can sum up cells that are adjacent to each other or non-adjacent cells.
  • The function can also be used to sum cells that are in different worksheets or different workbooks.
  • It skips all the blank cells or cells with texts while calculating.
  • The SUM function accepts up to 255 numbers inside it.

Conclusion

The SUM function is one of the math and trigonometry functions in Excel. If you have any questions regarding the SUM function, please comment below. Thanks!

(Visited 19 times, 1 visits today)

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *