Please help with determining the below formulas:

1) On the InventoryAudit worksheet, the cells in range A3:D17 need to be filled in based on the category that is listed in cell B1, "Massage". The table will then contain the information about each product within the listed category. Using named ranges already created in the Inventory worksheet, complete the following: In cell B3, create a formula to retrieve the item within each category in cell B1. Enter an INDIRECT function to return the item numbers by category. The function will reference cell $B$1 (absolute) and index the value of the intersection of row 3 (A3) and column. Nest the function in an IFERROR function to return a blank cell if no items exist within the category.

2) On the InventoryAudit worksheet in cell C3, create a formula to retrieve the projected sales for each item within the category in cell B1. Enter an INDIRECT function to return the item numbers by category. The function will reference cell $B$1 (absolute) and index the value of the intersection of row 3 (A3) and column 2. Nest the function in an IFERROR function to return a blank cell if no items exist within the category.

3) Create a formula to determine the total quantity sold within the category in cell B1. Enter a SUMIF function nested in an IF function to determine if B3 has a value. If B3 has a value, then you will sum the Trans_Sold if the Trans_Item meets the criteria in B3. If B3 does not have a value, then the cell is left blank. Select range B3:D3, and then double-click the Fill handle to copy the three formulas down through cell range B4:D17. Rows 7 through 17 will be blank because the Indirect function is referring to the named range for the value in cell B1, "Massage". The Massage named range only contains the four items. To test your formula, type Golf in cell B1, and then view the results. Type Massage in cell B1.

4) In cell C21, using a SUMIFS function, calculate the total quantity sold (Trans_Sold) per category (Trans_Category) per day (Weekday) in range B20:I26 based on two sets of criteria, C20 and B21. Use an appropriate mixed reference on the criteria cell references to be able to copy the formula through cell I26.

5) Calculate the total quantity sold per category in range D32:D51 based on the item in column B. Once this has been calculated, the total quantity delivered and ending inventory can be calculated. In cell D32, create a formula to sum the range Trans_Sold from the DailyTransactions worksheet if the criteria in B32 is found in the range Trans_Item from the DailyTransactions worksheet.

6) In cell E32, create a formula to sum the range Trans_Delivered if the criteria in B32 is found in the range Trans_Item. In cell F32, create a formula that subtracts the Total out (D32) from the Beginning inventory (C32) and then adds the Total in (E32).

D E F G H K M . N O P Projection Actual B 1 Category Massage 2 Category Item 3 1 4 2 5 3 6 4 7 5 8 6 9 7 10 8 11 9 10 11 12 13 14 15 12 13 14 15 16 17 18 19 20 21 22 23 24 Mon Tues Wed Thur Fri Sat Sun Categories Massage Golf Food Novelty Reading Clothing 25 26 27 28 29 30 Item Total in Ending Actual Turnover Description 31 32 Beginning Total out inventory 35 33 33 Max Stock Inventory Discrepancy 25 On Target 20 On Target 15 On Target 10 On Target 30 On Target 30 On Target A1 A2 A3 |A4 A5 34 48 0.00% Healthy Trail Mix 0.00% Resort Polo 0.00% Healthy Energy Bar 0.00% Spirits Lifted Through Yoga 0.00% Golf Tees 0.00% 35 10 36 52 37 A6 10 > Inventory Inventory Audit DailyTransactions