Basic SUM

Beginner

When you build a simple report in Excel, one of the most common tasks is adding up a list of numbers to get a total. The SUM function is built for exactly that.

In this sheet, you have monthly revenue figures in column B.

What you need to do

  1. Click cell B9 (the cell that says "Edit this cell").
  2. Type a SUM formula that adds the revenue values in cells B2 through B7.
  3. Press Enter.

When you’re done, cell B9 should show the total revenue for January through June.

Need some help?

Hint 1

Your total belongs in cell B9, and the numbers you need to add are in cells B2 through B7.

Hint 2

Use the SUM function with a single range (a start cell and an end cell). You can also click and drag to select the range instead of typing it.

Related function(s)
SUMAVERAGEMINMAXSUBTOTAL
More exercises
Simple percentage calculationBeginner
Find the maximum valueBeginner
Calculate Average SalesBeginner
Find the minimum valueBeginner
Back to exercises overview

Exercise