Menu
Coddy logo textTech
START LEARNING
flag En iconEnglishdown icon

Totals and Averages

Part of the Fundamentals section of Coddy's Excel journey — lesson 40 of 42.

challenge icon

Challenge

Easy

Extend your grade book with two calculated columns:

  1. Headers: Total in E1 and Average in F1
  2. Column E: each student's total score using SUM, E2 for Maya, E3 for Liam, E4 for Ava
  3. Column F: each student's average using AVERAGE, F2, F3, F4

Use ranges that cover each student's own row of scores. The tests will change some scores, real formulas will follow along, typed-in numbers won't.

Try it yourself

Sheet1
ABCDEFG
1StudentTest 1Test 2Test 3
2Maya788592
3Liam625872
4Ava958893
5
6
7
8
9
10
11
12
13
14

All lessons in Fundamentals

1Meet the Spreadsheet

What Is a Spreadsheet?Cells and ReferencesYour First CellsRows, Columns and the GridRecap: Meet the Grid

4Cell References

Referencing Other CellsFormulas That UpdateChained FormulasRanges from A1 to A10Recap: Cell References

7Decisions with IF

The IF FunctionWriting an IFComparison OperatorsNested IFsRecap: Decisions with IF

2Entering Data

Text and NumbersBuilding a Small TableEditing and Clearing CellsNumbers That Mean SomethingRecap: Entering Data

5Basic Functions

What Is a FunctionThe SUM FunctionThe AVERAGE FunctionMIN and MAXCOUNT and COUNTACombining FunctionsRecap: Basic Functions

8Project: Grade Book

Grade Book SetupTotals and AveragesPass or Fail with IFFinishing the Grade Book

3Your First Formula

What Is a Formula?Writing a FormulaFormulas with CellsArithmetic OperatorsOrder of OperationsRecap: First Formulas

6Working with Text

Joining TextUPPER and LOWERMeasuring Text with LENLEFT, RIGHT and MIDRecap: Working with Text