SUM practice: add a range with confidence

SUM is often the first Excel function you learn, and it remains useful long after the basics. It adds numeric values in a range so that you can total orders, spending, hours, or inventory. The most useful habit is to check the boundaries of the range before trusting the answer.

Start with the business question

Imagine a sales report with a header in row 1 and eight orders in rows 2 through 9. Revenue is in column E. To answer “What was our total revenue?” you need every numeric revenue cell from E2 to E9.

=SUM(E2:E9)

The equals sign begins the formula. SUM names the operation. The colon means “all cells from the first address through the last.” Parentheses hold the function’s arguments. This is more readable than adding eight separate references.

Check three things before you submit

First, choose the correct metric. Column D may contain units while column E contains dollars. Both are numbers, but they answer different questions. Second, include the final row. E2:E8 can return a perfectly reasonable-looking total while silently omitting the last order. Third, make sure imported revenue is stored as numbers. SUM ignores text in a referenced range; a number stored as text may be skipped.

Why not type the total?

A typed answer may be correct today but becomes stale when an order changes. Referencing source cells makes the calculation repeatable. Cellcraft’s checker changes numeric inputs after evaluating the visible sheet, which helps distinguish a reusable formula from a memorized result.

Try the same pattern at work

Replace the revenue range with the hours, costs, or quantities in your own workbook. If you convert your data to an Excel table, structured references can make a growing dataset easier to maintain; this browser lab uses ordinary cell references. For filtered reports, learn how SUBTOTAL differs from SUM in Excel. SUM does not automatically mean “visible rows only.”

Practice objective

Open the interactive quest below and calculate the full revenue total. Then try deliberately leaving off one row and observe the feedback. Repairing a plausible mistake is often more memorable than copying the example once.

Continue your adventure

Use the formula spellbook for syntax or explore the full quest map. You can practice in the browser and download workbooks without creating an account.