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), and the 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 ...