Home › Learn Excel › Lesson 1

Adding up in Excel: SUM practice

Eight short exercises, from adding two cells to SUMIFS with two conditions. Tips show you what to type next; later on you write the formula yourself.

Add two cells. Every formula in Excel starts with =.
B2 and B3 are cell references: they point to the values in column B, rows 2 and 3. Add up the January revenue in B4.
Add three cells. With + you can add up as many cells as you like. Add up the first-quarter sales in B5.
Add a range with SUM. With many cells, + gets long. SUM adds up a whole range: B2:B6 means B2 up to and including B6. Add up the hours worked this week in B7.
Your turn: SUM. Now without tips. Use SUM and select the range yourself. Add up all expenses in B6.
A range over two columns. A range can span several columns. B2:C4 is a block of six cells: from B2 to C4. Add up all sales, online and in store, in B5.
Add with a condition: SUMIF. SUMIF only adds the rows that meet a condition. It has three parts: where Excel looks, what it looks for, and what it adds up. Add up the amounts for the North region in D2.
Your turn: SUMIF with a cell. Instead of typing the condition, you can point to a cell. Change that cell later and the total updates by itself. Add up the amounts for the region in D2, in E2.
Several conditions: SUMIFS. SUMIFS adds up with several conditions at once. Watch out: here the range to add up comes first, then each range with its condition. Add up the laptops sold in the North region in E2.