What action is used when Excel suggests the wrong range after clicking the SUM button?

Correct the range by dragging the appropriate cells in the worksheet. You could also type in the correct range.