$1\mathrm{.}6$ Calculate the sample $1\mathrm{.}7$ Calculate the number of diamonds with a color rating of D$.$ a $.$ Place your calculation in cell M$13$ b $.$ Use the COUNTIF function $..$ Reference the values for color $($ C$4$: C$354)$ and the rating value $($ L$13)$ in your formula so that you can reuse your formula to complete the remaining count calculations $.$ d $.$ Reuse your formula to calculate the number of diamonds with the remaining color ratings $($ M$14$ : M$19)31\mathrm{.}8$ Calculate the number of diamonds with a clarity rating of IF$.$ a $.$ Place your calculation in cell P$13$ b $.$ Use the COUNTIF function $..$ Reference the values for clarity D$4$ :D$354))$ and the rating value $(013)$ in your formula so that you can reuse your formula to complete the remaining $100\%+$