1. On the RevenueReport worksheet, add a COUNTIF function in cell F15 to count the number of Loyalty program members ("Yes") using the Loyalty named range. In cell F16, create a formula to indicate if the loyalty goal (F14) has been met by the quantity (F15). The cell should display "Goal Met" if the goal has been met or "Goal Not Met" if not met (Use the IF function and perform a greater than comparison; >[30/F14]).
2. On the RevenueReport worksheet, add a COUNTIFS function in cell G5 to count the number of coupons used by each category (F5:F7) in the morning (F3) shift (use absolute referencing for F3). You need to use the Shift and Coupon_Num ranges. Copy/paste the formula to G6:G7.

3. On the RevenueReport worksheet, add an AVERAGEIF function in cell B9 to determine the average sale for the customer listed in cell B8. You should use the Cust_Cat and Line_Item_Total ranges in the formula.

   I NEED FORMULAS!!

Revenue Report Revenue Report