Need correct Formula according to below instructions On the RevenueReport worksheet, add a COUNTIFS function in cell G5 to count the number of coupons used by each category in the morning (F3) shift You need to use the Shift and Coupon Num ranges Copy paste the formula to G6 G7 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 On the RevenueReport worksheet, add an AVERAGEIFS function in cell B10 to determine the average sale for the customer listed in cell B8 by pay type Extend the formula in B10 to B11 using the same customer type and the payment type in A11 On the RevenueReport worksheet, add a SUMIF function in cell B21 to sum the total amount of sales for the shift in cell B20 Use the Shift and Line Item Total ranges in the formula On the RevenueReport worksheet, add a SUMIF function in cell B4 to sum the total amount of revenue per customer typ Use the Cust Cat and Line Item Total ranges in the formula Copy paste the formula to B5 B6 On the RevenueReport worksheet, add a formula with the SUMIFS function in cell B24 to sum the total amount of sales per SKU ( A24 ) and per customer type ( B23 ) Use the Cust Cat, SKU Cat, and Line Item Total ranges in the formula Extend the formula to C24 D24 and then to B25 D27 Revenue Report AH Coupon Target Revenue Coupon Used Customer Type Guest Employee Unknown Shift Category Transaction Count Report 1 1 2 3 4 Morning Category RM15 EMP25 LOY20 Employee Customer Type Average Sale Cash Ccard Coupon LOY20 Number of times coupon used $ 30 1,800 00 100 Revenue Goal Qty Sold Goal Revenue Goal Result Qty Sold Goal Result Loyalty Goal Qty Loyalty Goal Result 20 Goal Not Met Goal Met Goal Met Afternoon Sum of Shift Guest Employee Unknown Sum of Revenue Gift Food Coffee Other

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 19, 2024

Need correct Formula according to below instructions. On the RevenueReport worksheet, add a COUNTIFS function in cell G5 to count the number of coupons used

Need correct Formula according to below instructions. image text in transcribed

On the RevenueReport worksheet, add a COUNTIFS function in cell G5 to count the number of coupons used by each category in the morning (F3) shift. You need to use the Shift and Coupon_Num ranges. Copy/paste the formula to G6:G7.
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.
On the RevenueReport worksheet, add an AVERAGEIFS function in cell B10 to determine the average sale for the customer listed in cell B8 by pay type. Extend the formula in B10 to B11 using the same customer type and the payment type in A11.
On the RevenueReport worksheet, add a SUMIF function in cell B21 to sum the total amount of sales for the shift in cell B20. Use the Shift and Line_Item_Total ranges in the formula.
On the RevenueReport worksheet, add a SUMIF function in cell B4 to sum the total amount of revenue per customer typ Use the Cust_Cat and Line_Item_Total ranges in the formula. Copy/paste the formula to B5:B6.
On the RevenueReport worksheet, add a formula with the SUMIFS function in cell B24 to sum the total amount of sales per SKU (A24) and per customer type (B23). Use the Cust_Cat, SKU_Cat, and Line_Item_Total ranges in the formula. Extend the formula to C24:D24 and then to B25:D27.

Revenue Report AH_Coupon_Target Revenue Coupon_Used Customer Type Guest Employee Unknown Shift Category Transaction Count Report 1 1 2 3 4 Morning Category RM15 EMP25 LOY20 Employee Customer Type Average Sale Cash Ccard Coupon LOY20 Number of times coupon used $ 30 1,800.00 100 Revenue Goal Qty Sold Goal Revenue Goal Result Qty Sold Goal Result Loyalty Goal Qty Loyalty Goal Result 20 Goal Not Met Goal Met Goal Met Afternoon Sum of Shift Guest Employee Unknown Sum of Revenue Gift Food Coffee Other