Chapter 7 Case study: monthly sales report ・ MISSION 27

Mission 27: Sales total by salesperson

📋 Mission list

Task

This is the September sales list. In F2:F4, show the total sales of each salesperson.

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 7 startsCase study: monthly sales report

Chapter 7 ・ MISSION 27

Sales total by salesperson

This is the September sales list. In F2:F4, show the total sales of each salesperson.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =SUMIF($A$2:$A$9,E2,$C$2:$C$9)

Leave the reference that should move when copied (E2) as it is, and lock only the ranges that should stay put with $.

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