All lessons

SUM & AVERAGE

15 min

Everything starts here. Add a column of numbers and find the average.

Step 1 of 3

In this lesson

  • SUM(range) adds numeric cells
  • AVERAGE(range) returns the mean
  • Ranges like A2:A10 are typed the same way you drag them
Live practice sheet
ABCDEFGHI
1DateRegionOrder #Revenue
22026-01-02North10011250
32026-01-03South10023400
42026-01-05North10038700
52026-01-08West10045200
62026-01-11North100511500
72026-01-13South100618100
8
948150
108025
11
12
13
14

The highlighted cells show where this lesson's formula lives. Use the prompts on the left to rebuild it yourself.