Adding cells using SUM in Excel | Scribe

    Adding cells using SUM in Excel

      Learning how to add numbers in Excel

      information ordinal icon
      Here's a quick GIF showing how it works.
      1
      Click "B11" and type [[=SUM(B8+B9+10)]] then press [[Enter]]
      Click "B11" and type [[=SUM(B8+B9+10)]] then press [[Enter]]
      information ordinal icon
      Try it yourself.
      2
      Click "B11"
      3
      Type [[=SUM(B8+B9+10)]] then press [[Enter]] You can see each cell in the formula is highlighted with a different colour.
      4
      Click to scroll down to next question

      Adding a range of cells together

      information ordinal icon
      Adding a range of cells is quicker than typing all the numbers. You only need to type the first and last cell in the range.
      5
      Click "B51"
      6
      Type the first and last numbers of the 'range'. Put a colon [[:]] between them. The formula is [[=SUM(B48:B50)]]
      7
      When you type the 'range', the cells and cell numbers will be blue.
      When you type the 'range', the cells and cell numbers will be blue.
      8
      You can also see and edit the formula in the "Formula Bar"
      9
      When you click [[Enter]] the answer will appear. 4+8+6= 18
      10
      Scroll down to the next question.
      11
      Click "B11"

      Click and drag to add range of cells

      12
      Where do you want the answer? Click on that cell.
      13
      Click on the top cell, let go of the left mouse button. Then click the left button again and hold the button down. Drag your hand to the bottom cell and then let go. All the cells added up should have a blue background.
      Click on the top cell, let go of the left mouse button. Then click the left button again and hold the button down. Drag your hand to the bottom cell and then let go. All the cells added up should have a blue background.
      14
      Can you spot the error in this formula?