Sumif

For each product, determine the total number of units and dollar volume sold. ( 3 marks)  2. Determine the total revenue earned before December 10, 2005. (1 mark) 3. Determine the total units sold by salespeople whose last names begin with C. (1 mark) 4. Determine the total revenue earned by people who have five letters in their names. (1 mark) 5. How many units were sold by people other than Colleen? (1 mark) 6. How many units of makeup were sold from January 15, 2004, through February 15, 2005? (1 mark)  7. The file Sumifrows.xlsx contains sales data during several winter, spring, summer, and fall quarters. Determine average sales during the winter, spring, summer, and fall quarters. (2 mark)