The Dollar Shack sells two different types of party supplies…
The Dollar Shack sells two different types of party supplies – balloons and hats – in six different colors. The table below shows the number of units that were sold this quarter by type and color. For each color, you would like to know what percent of the units sold were balloons and what percent were hats. You want to type a formula in cell G4 that you can copy the formula to the right and down to cell H9 in order to calculate the appropriate values for each color and item type. What formula should you type in cell G4?