
Determining the weekly sales for each
department
This example involves an unsorted list of sales by individual
employees from different departments. Your task is to calculate the
weekly sales for each department.
4
To determine weekly sales:
1. Using the data shown in Figure 14-27, select cells F6:F9.
2. Type the formula =SUMIF($A$6:$A$16,E6,
$C$6:$C$16).
3. Press <Ctrl+Enter>.
364
Chapter 14
Figure 14-27