Chapter 2 Counting and adding with conditions ・ MISSION 8

Mission 8: Add up with two conditions

📋 Mission list

Task

In F2, find the total sales of products in the category in F1 (Food) with sales under 1000.

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 8

Add up with two conditions

In F2, find the total sales of products in the category in F1 (Food) with sales under 1000.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =SUMIFS(C2:C8,B2:B8,F1,C2:C8,"<1000")

SUMIFS(sum_range, range1, criteria1, range2, criteria2). Unlike SUMIF, the range to add comes first.

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