SUM function
A function is a named calculation; SUM normally ignores text in referenced cells, depending on spreadsheet software. Inspect the selected range, including hidden rows and intended totals, to avoid omissions or double counting. AutoSum can suggest a range but the user must verify it.
Worked example
If B2, B3 and B4 hold $10, $20 and $30, =SUM(B2:B4) gives $60. Including a separate $60 subtotal in the same sum would incorrectly give $120.
Common mistake
Accepting an automatically suggested range without checking whether it includes the intended cells or duplicate subtotals.
Where it appears in your exams
| Qualification | Exam | Relationship | Period |
|---|---|---|---|
| ACCA | MA | Supporting | September 2026–June 2027 |
| FIA | FMA | Supporting | September 2026–June 2027 |