Next, you want to count the Rank scores for women's clothing. In cell O$4,$ enter a formula to count the rank of the product line for women in cell range H$5$:H$16$ based on the value in cell N$4.$ Ensure your formulas will be copyable to the cells below. Copy the formula but not the formatting through cell range O$4$:O$8.$