In cells F$5$:F$17,$ calculate the yearly sales totals for the women's clothing line. In cells F$21$:F$33,$ calculate the yearly sales totals for the men's clothing line. In B$36$:F$36,$ calculate the grand totals of women's and men's clothing sales.

In B$37$:E$37,$ calculate the percentage of sales from women's clothing. Format as Percentage and display zero decimal places. In B$38$:E$38,$ calculate the percentage of sales from men's clothing. Format as Percentage and display zero decimal places.