Sheets Exercises
Free ·
Lesson 3: SUM, AVERAGE, COUNT
0 pts
✕
0
Step 1 of 3
Add up the costs
Click cell
B7
. Type a formula that adds every cost from
B2
to
B6
.
Show formula shape
=SUM(
first cell
:
last cell
)
↶
↷
100%
$
%
.0
B
I
Data
B7
fx
A
B
C
D
E
F
1
Item
Cost
2
Rent
1,200
3
Groceries
340
4
Phone
45
5
Transit
96
6
Streaming
28
7
Total
8
Average
9
Count
10
11
12
13
14
Budget
B7
=
(
:
,
)
Check my answer