Chapter 20. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions

Questions answered in this chapter:

  • I’m a sales manager for a makeup company and have summarized the following information for each sales transaction: salesperson, date of sale, units sold (or returned), and 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 by someone other than a specific salesperson?

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

Get Microsoft Excel 2013: 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.