Skip to Main Content
Microsoft Excel Functions & Formulas
book

Microsoft Excel Functions & Formulas

by Bernd Held
September 2006
Beginner to intermediate content levelBeginner to intermediate
397 pages
13h 15m
English
Jones & Bartlett Learning
Content preview from Microsoft Excel Functions & Formulas
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
Because of the different sizes of each department, the weekly sales
figures do not really indicate anything about the performance of
each salesperson. As an ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel - Advanced Formulas And Functions

Microsoft Excel - Advanced Formulas And Functions

Guy Vaccaro

Publisher Resources

ISBN: 9781598220117