Let’s take a look. Here we have a worksheet with some incorrect formulas. Let’s check these formulas against the instructions to understand what’s wrong. An easy way to check a formula is to double-click the cell. To get back out of edit mode without making changes, just press Escape. We can see that the first formula is adding the wrong cells together. It should be adding B7 to D9, but it’s adding B7 to D6. Let’s press Escape and look at the next formula. The next formula is manually adding only the first three cells in the range F7:F10, so it’s missing F10. And we really should use the SUM function here. The last formula is summing the range H8:H11. It’s using the SUM function, which is good, but it’s including an extra cell. Now let’s fix the problems. To edit an existing formula, just double-click, and revise as needed. Excel also has a cool way to let you change cell references by dragging. If we undo our change, and then edit the cell again, we can just drag the reference to D6 onto the cell D9, and press Enter.  The next formula would be better rewritten using the SUM function. So we’ll just replace the formula. In our last example, we just need to adjust the range being used by the SUM function. We can do that by entering edit mode and using one of the highlighted handles to size the range correctly.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.