Chapter 2 Counting and adding with conditions ・ MISSION 6
Mission 6: Add up sales for a category
Task
In F2, find the total sales of the products in the category in F1 (Food).
F2fx
A
B
C
D
E
F
1
Product
Category
Sales
Category
Food
2
Apples
Food
1200
Total sales
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 6
Add up sales for a category
In F2, find the total sales of the products in the category in F1 (Food).
A
B
C
D
E
F
1
Product
Category
Sales
Category
Food
2
Apples
Food
1200
Total sales
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
Food
2
Apples
Food
1200
Total sales
4540
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: =SUMIF(B2:B8,F1,C2:C8)
SUMIF takes three things: where to look, what to match and what to add. If you swap the first and third, the result is 0.
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).