Mixing Ranges and Single Cells in SUM

So far you have given SUM one tidy range like A1:A10. But real spreadsheets are rarely that neat. Numbers you want to add are often scattered across the sheet.

The good news: SUM accepts multiple arguments. You can list several ranges and single cells in one formula, separated by commas.

In this lesson you will combine ranges and individual cells inside a single SUM call.

The full shape of SUM allows many arguments:

=SUM(arg1, arg2, arg3, ...)

Each argument can be a range or a single cell. SUM adds all of them together into one total.

The comma is the key. It separates one argument from the next, telling SUM to keep adding everything you list.