Skip to main content

Total a column with SUM

20%
SUM

=B2+B3+B4+B5+B6+B7 works, and it is the wrong answer. It takes longer to type, it is easy to miss a cell, and it tells you nothing when you read it back.

=SUM(B2:B7) says what it means: total this range. A function is a name, a bracket, and what it should work on.

In B9, use SUM to total the six weekly figures in B2 to B7.

The grid for this exercise needs a free profile.

Everything above is yours to read either way. 19 exercises stay open with no profile at all.