SUM Function
The SUM Function
The Essential Tool for Totaling Data
The SUM function is the professional way to add numbers. While you could type =A1+A2+A3, using SUM is faster, cleaner, and automatically adjusts if you insert new rows into your list.
Syntax & Usage
=SUM(range_or_numbers)
Example: =SUM(B2:B6)
Meaning: Add every value from cell B2 through B6.
Why is SUM so flexible?
You aren't limited to just one range. You can add multiple different groups of cells at once by separating them with a comma:
=SUM(A1:A5, C1:C5)
Adds two separate columns together.
=SUM(A1:A10, 500)
Adds the range plus an extra 500.
⚡ The AutoSum Visual Guide
Instead of typing, go to the Home Tab and look for the Σ AutoSum button on the far right. Excel will "guess" which cells you want to add and write the entire formula for you. Just press Enter to confirm!
💡 Skill Eco Pro-Tip: Fast Check
Need to know a total without writing a formula? Simply highlight a group of numbers with your mouse. Look at the bottom right of your Excel window (the Status Bar). It will show you the Sum instantly!