The estimated range highlights. Edit the range by left-clicking and dragging the cursor over all values in the row to sum, if desired. The selected rows are highlighted.

SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.

How to Add the Difference Range In Excel. The simplest way to add cells in Microsoft Excel is using the plus operator, such as "=A1+A2," but that method fails when adding different ranges.

Want to quickly add up rows or columns of data in your gradebook (or elsewhere)? The AutoSum function makes it easy.