i am stuck on these last question and need help

/in /by

On the InventoryAudit worksheet in cell D3, 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, “message” The Massage name range only contains fthe four items. To test your formula, type Golf in cell B1 and then view the results. Type Message in cell B1

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.