Chapter 2 Counting and adding with conditions ・ MISSION 7
Mission 7: Count sales of 1000 or more
Task
In F1, count the products with sales of 1000 or more.
F1fx
A
B
C
D
E
F
1
Product
Category
Sales
1000 or more
2
Apples
Food
1200
3
Notebook
Stationery
450
4
Bananas
Food
980
5
Pen
Stationery
300
6
Grapes
Food
1500
7
Ruler
Stationery
150
8
Peaches
Food
860
9
Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.
Chapter 2 ・ MISSION 7
Count sales of 1000 or more
In F1, count the products with sales of 1000 or more.
A
B
C
D
E
F
1
Product
Category
Sales
1000 or more
2
Apples
Food
1200
3
Notebook
Stationery
450
4
Bananas
Food
980
5
Pen
Stationery
300
6
Grapes
Food
1500
7
Ruler
Stationery
150
8
Peaches
Food
860
9
A
B
C
D
E
F
1
Product
Category
Sales
1000 or more
2
2
Apples
Food
1200
3
Notebook
Stationery
450
4
Bananas
Food
980
5
Pen
Stationery
300
6
Grapes
Food
1500
7
Ruler
Stationery
150
8
Peaches
Food
860
9
The tutorial is On. Change this in theMission list.
Functions used in this mission
Example formula: =COUNTIF(C2:C8,">=1000")
Comparison criteria: ">=1000" (at least), "<1000" (less than), "<>0" (not 0). Pass the operator as part of the text.
To practice one function at a time:Function drillExcel function list
* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.
* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).