One way to do this is to use a full row reference.
You will see Excel go for the entire row.
Advantages and risks
The main advantage to full row references is simplicity.
However, full row references come with certain risks.
One risk is that you may accidentally include extra data in a calculation.
These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
SUM can handle up to 255 individual arguments.
