Sum

Updated: 02/01/2021 by Computer Hope

Sum may refer to any of the following:

1. In mathematics, a sum is the total obtained from adding numbers. For example, the sum of two and two is four.

2. Sum is chat slang for some.

Sum

3. In Microsoft Excel, sum is a formula syntax for adding, subtracting, multiplying, dividing, or getting the total numerical content of specific cells. Below are examples of how the sum formula may be used.

  • =sum(a1+a10) — adds cell A1 and A10.
  • =sum(a1-a10) — subtracts A1 from A10.
  • =sum(a1:a10) — adds all cells in the range between A1 and A10.
  • =sum(20+30) — calculates 20+30 to show 50 in the cell.
  • =sum(a1+30) — takes the value in the A1 cell and adds 30.
  • =sum(10*a1)multiply the value in the A1 cell and adds 30.
  • =sum(2/a1)divide 2 by the value in the A1.
Tip

When a formula is added to a cell, its results are what show in the cell.

AutoSum, Average, Spreadsheet terms, SUMIF, Total