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.

Zero2Hero — Zéro2Héros