entering formulas gross margin % divide by Week Total Sales
 

I am doing a worksheet in class and am new to excel. I have to calculate the
Gross Margin % for all items by the week total Sales for all items. Enter
the appropriate formula in the cell that will also round the result to four
decimal places and am told to not use the intermediate formula in any cell to
calculate the weekly total for all items but rather incorporate the SUM
function in to the formula