SUM Function

Freebeginner 15 min4 tasks0/48 pts

SUM adds numbers. Give it a range (C2:C10), single cells, or several of each separated by commas. Text and blank cells inside the range are ignored.

Syntax

SUM(number1, [number2], …)

Example: =SUM(C2:C10) adds every sale. =SUM(C2:C4,C10) adds three cells plus one more.

Common mistakes

Range stops one row early after new data was added.
Numbers stored as text are skipped silently.

Data Shortcuts COUNT Function