Sheets Exercises
Free ·
Lesson 10: SUMIF, SUMIFS, AVERAGEIF
0 pts
✕
0
Step 1 of 4
Total one status
In
F2
, add amounts in
C2:C7
when the matching status in
B2:B7
is Paid.
Show formula shape
=SUMIF(
criteria range
,
criterion
,
sum range
)
↶
↷
100%
$
%
.0
B
I
Data
F2
fx
A
B
C
D
E
F
G
H
1
Region
Status
Amount
Summary
2
East
Paid
120
Paid total
3
West
Paid
80
Total over 100
4
East
Open
60
East paid total
5
East
Paid
150
West average
6
West
Open
90
7
East
Paid
70
8
9
10
11
12
Sales
F2
=
(
:
,
)
Check my answer