Chapter 2 Counting and adding with conditions ・ MISSION 9
Mission 9: Average for a category
Task
In F2, find the average sales of the products in the category in F1 (Stationery).
F2fx
A
B
C
D
E
F
1
Product
Category
Sales
Category
Stationery
2
Apples
Food
1200
Average
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 9
Average for a category
In F2, find the average sales of the products in the category in F1 (Stationery).
A
B
C
D
E
F
1
Product
Category
Sales
Category
Stationery
2
Apples
Food
1200
Average
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
Category
Stationery
2
Apples
Food
1200
Average
300
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: =AVERAGEIF(B2:B8,F1,C2:C8)
AVERAGEIF uses the same order as SUMIF and returns the average instead of the total.
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).