O'Reilly logo

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 42. Creating Subtotals

Joolas is a small company that manufactures makeup. For each transaction, they track the name of the salesperson, the location of the transaction, the product sold, the units sold, and the revenue. They want answers to the following questions:

  • Is there an easy way to set up a worksheet to calculate total revenue and units sold by region?

  • Can I also obtain a breakdown by salesperson of sales in each region?

We know that PivotTables can be used to "slice and dice" data in Microsoft Office Excel 2007. Often, however, we’d like an easier way to summarize a list or a database within a list. In a sales database, for example, we might want to create a summary of sales revenue by region, a summary of sales revenue by product, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required