I have attached the spreadsheet needed to answer the following question.

1. In the worksheet named 'SUMIFS, etc.' do the following:
   1. Write a 'COUNTIFS' formula to count the total number of observations that have a customer number greater than 201 and are also located in the NE sales region.
   2. Write a 'SUMIFS' formula to summarize the total sales for customers that are in the SE sales region and that occurred in the last two quarters of the year.
   3. Write a 'AVERAGEIFS' formula to compute the average sales for customers with customer numbers 100 and 200.
   4. In a column to the right of the data, create a drop-down list with the names of the customers.

DE Location SE Quarter 1 SE 2 SE SW SW SW SW NE 1 Customer Number 101 101 101 101 201 201 201 201 301 301 301 301 401 401 401 401 501 501 501 501 Customer name Fighting Owl Co. Fighting Owl Co. Fighting Owl Co. Fighting Owl Co. Lexington Industries Lexington Industries Lexington Industries Lexington Industries Kennesaw Supply Kennesaw Supply Kennesaw Supply Kennesaw Supply Chastain Corporation Chastain Corporation Chastain Corporation Chastain Corporation Jonquil Company Jonquil Company Jonquil Company Jonquil Company NE Sales $5,200 $6,450 $8,800 $13,540 $3,200 $5,000 $6,150 $10,500 $2,130 $4,500 $5,580 $9,350 $3,250 $4,800 $6,450 $9,940 $4,250 $7,520 $10,150 $12,120 NE SE SW SW SW 3 4 SW