SUM

In this lesson

1. 1. Add two cells

   All formulas start with =.

   B2 and B3 are cell addresses. The formula adds the numbers in them.

2. 2. The SUM function

   Excel has many built-in functions. Each one does one job.

   SUM adds up its inputs. The inputs go inside the brackets, with commas between them.

3. 3. Add a range

   More revenue lines are now in rows 4 to 6.

   A colon means from one cell to another. B2:B6 means every cell from B2 to B6.

4. 4. Your turn: February

   February numbers are now in column C.

5. 5. Mix a range and a number

   SUM can add ranges and numbers together.

   The CFO says February revenue was 100 too low.

6. 6. Try it yourself

   January also missed 50 of revenue.

Part of Core Formulas & Functions. Short lessons with practice in a real spreadsheet, checked as you go.