Sheets ExercisesFree · Lesson 9: COUNTIF and COUNTIFS
0 pts
✕
0
Step 1 of 4

Count one text value

In G2, count the cells in C2:C7 that equal Paid.

Show formula shape
=COUNTIF(range, criterion)
100%
G2fx
A
B
C
D
E
F
G
H
1
Invoice
Region
Status
Amount
Count
2
I-201
East
Paid
180
Paid invoices
3
I-202
West
Open
75
Over 100
4
I-203
East
Open
125
East and paid
5
I-204
East
Paid
90
West over 100
6
I-205
West
Paid
220
7
I-206
West
Paid
140
8
9
10
11
12
Invoices
G2