➕ The Aggregator

Goal: Calculate the Total Cost of the shopping list.
SUM adds up all numbers in a selected range.

Running Total: $0
Ready...

💻 Formula Structure

=SUM(number1, [number2], ...)
  • 1. Numbers: A range of cells (A1:A5), individual numbers (1, 2), or separate cells (A1, C1).
-- Add everything in Column B
=SUM( B2:B5 )
Total:
-

⚠️ Common Pitfalls

🚫 Text is Ignored
SUM ignores cells containing text (like "N/A" or "Ten"). It treats them as 0.
🎹 Shortcut Tip
Press Alt + = to instantly insert a SUM formula that guesses the range above it.