Chapter 21. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions

Questions answered in this chapter:

  • I’m a sales manager for a makeup company and have summarized for each sales transaction the following information: salesperson, date of sale, units sold (or returned), total price received (or paid out for returns). How can I answer the following questions?

    • What is the total dollar amount of merchandise sold by each salesperson?

    • How many units were returned?

    • What is the total dollar amount of sales in or after 2005?

    • How many units of lip gloss were sold? How much revenue did lip gloss sales bring in?

    • What is the total dollar amount of sales made by someone other than a specific salesperson?

    • What is the average number of units sold in each transaction ...

Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.