FormulaCamp
Completed
4. Excel Functions · Math and Counting · 15 min

1. The SUM Function

Lesson 1 of 25
Task 1 of 2
  1. In D7, calculate the total amount of the purchase.

Lesson theory

=SUM(D2:D6) adds up all the cells from D2 to D6. The colon means "from … to".

Arguments are separated by commas ,: =SUM(A1,A3,A5) adds three separate cells.

fx

Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo

Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page