Excel: adding up with SUM
Sign up free to unlock this topic
Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.
Try the free sample: The ideal gas law · Have a class or homeroom code? Join here
Key idea: Excel: adding up with SUM
SUM adds every number in a range. A range is first cell:last cell, like B2:B9, and it can cover several columns, like B2:C9.
Key words
- =SUM(B2:B9)
- Adds B2 through B9.
- AutoSum
- The ÎŁ button writes a SUM for you.
🔎 What to look for: Check that the range starts and ends on the right rows, without the heading.
