wha do you do after you use =sum(
You specify the cells holding the numbers to add together.
This can be
- a list of individual cell addresses:
=SUM(A2;B7;C3)
- a rectangular cell range, specified by two corners, or by column letters only for entire columns:
=SUM(A2:C7;D:F)
- a named range:
=SUM(Expenses)
- a combination of the above.
=SUM('Cost of living';A3;C:D)
Note: Colon between the “spanning addresses” for a range. Semicolon between elements. Single quotes around names which contain spaces. (Comma is allowed instead of semicolon if the setting for decimal separator does not specify comma.)