Chapter 2 Counting and adding with conditions ・ MISSION 5

Mission 5: Count items in a category

📋 Mission list

Task

In F2, count the products in the category in F1 (Food). You can point to F1 for the condition.

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 startsCounting and adding with conditions

Chapter 2 ・ MISSION 5

Count items in a category

In F2, count the products in the category in F1 (Food). You can point to F1 for the condition.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =COUNTIF(B2:B8,F1)

You can write the COUNTIF criteria as "Food" or point to a cell that holds it. If you point to the cell, you can count another category just by changing F1.

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).