Lesson 4: SUM and AVERAGE
- B8: type
=SUM( - Drag from B2 to B7, close the ) and press Enter
| A | B | |
|---|---|---|
| 1 | Student | Score |
| 2 | Noah | 85 |
| 3 | Ethan | 92 |
| 4 | Maya | 78 |
| 5 | Jonah | 64 |
| 6 | Sarah | 95 |
| 7 | Oliver | 70 |
| 8 | Sum | |
| 9 | Average |
- B8 = 484, using SUM
All lessons
✍️ 1. Typing in cells
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
The SUM and AVERAGE functions in Excel: the total and the average of a range of cells. B2:B7 means "from B2 to B7". AVERAGE ignores empty cells, so a student who skipped the test does not pull the average down. This is the power of Excel: change one number and everything is recalculated.
Explore more: Excel course: all lessons, and Drag and fill.