← All questions

Windows

What does SUM mean in Excel?

695.What does SUM mean in Excel?

SUM is Excel’s adding word — short for the sum total, the answer you get when numbers are added together. When you see =SUM(B2:B5) in a spreadsheet, Excel is saying: add up every number from cell B2 down to cell B5, and put the answer here.

  • The = at the front tells Excel a formula is coming — without it, Excel treats what you typed as a word.
  • SUM is the job you are asking for: add.
  • B2:B5 is where — every cell from B2 to B5. The colon means “everything between these two, included.”
  • The cell shows the answer, not the formula. Click the cell and the formula appears in the long formula bar above the columns.

To use it yourself: click the cell under your numbers, type =SUM(, click the first number, Shift-click the last, type ), press Enter. Or use the button Microsoft built for it: Home tab, AutoSum. The same word, written exactly the same way, also works in Google Sheets and LibreOffice Calc. The full walk-through — SUM, AVERAGE, IF, and the fixes for the errors everybody meets — is in Excel Formulas: Let the Sheet Do the Sums.

In short: SUM means “add these up.” =SUM(B2:B5) adds every number from B2 to B5, and the cell shows the answer.