Scribd
Upload
54 views6 pages

COUNTIF (Range, Criteria) 2 COUNTIF (C6:C13,"Lucy") 1 Lucy 2 Elizabeth 3 Martin 4 Andrew 5 Lucy 6 Jennifer 7 Geoffrey 8 Abraham

The document explains the COUNTIF function in Excel. COUNTIF counts the number of cells that meet a certain criteria in a range. It provides examples counting cells that contain the name "Lucy", amounts greater than or equal to 500, and descriptions containing "apple". The last examples show counting unique and duplicate descriptions in a list. COUNTIF allows counting cells based on various criteria in a range.

Uploaded by

maznoer
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
54 views6 pages

COUNTIF (Range, Criteria) 2 COUNTIF (C6:C13,"Lucy") 1 Lucy 2 Elizabeth 3 Martin 4 Andrew 5 Lucy 6 Jennifer 7 Geoffrey 8 Abraham

The document explains the COUNTIF function in Excel. COUNTIF counts the number of cells that meet a certain criteria in a range. It provides examples counting cells that contain the name "Lucy", amounts greater than or equal to 500, and descriptions containing "apple". The last examples show counting unique and duplicate descriptions in a list. COUNTIF allows counting cells based on various criteria in a range.

Uploaded by

maznoer
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

COUNTIF function

COUNTIF(range, criteria)
Task
1
2
3
4
5
6
7
8

Name
Lucy
Elizabeth
Martin
Andrew
Lucy
Jennifer
Geoffrey
Abraham

=COUNTIF(C6:C13,"Lucy")

COUNTIF function
COUNTIF(range, criteria)
Invoice
1
2
3
4
5
6
7
8

Amount
512
298
674
960
796
940
77
848

=COUNTIF(C6:C13,">=500")

COUNTIF function
COUNTIF(range, criteria)
Price
10
20
15
21
5
10
5
15

Description
Watermelon
Banana, Pear
Orange, Apple
Kiwi, Pineapple
Lemon, Banana
Apple, Pear
Apricot, Pear
Banana, plum

=COUNTIF(C6:C13,"*apple*")

"*apple*")

COUNTIF function
COUNTIF(range, criteria)
Description
Watermelon
Banana
Orange
Kiwi
Lemon
Apple
Apricot
Banana
Pear
Apple
Pineapple
Banana
Pear
Pear
plum

1
1
1
1
1
1
1
2
1
2
1
3
2
3
1

=COUNTIF($B$6:B6,B6)

=COUNTIF($B$6:B20,B20)

COUNTIF function
COUNTIF(range, criteria)
Description
Watermelon
Banana
Orange
Kiwi
Lemon
Apple
Apricot
Banana
Pear
Apple
Pineapple
Banana
Pear
Pear
plum

1
3
1
1
1
2
1
3
3
2
1
3
3
3
1

=COUNTIF(B6:B20,B6:B20)

You might also like