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 count individual cells within a row by their fill color in Excel Your email has been sent The article How to easily sum values by a cell’s background color in Excel shows you an easy way to ...