$9$

The $2-$Summary worksheet contains data to insert conditional math and statistical functions to provide summary data. First, you want to count the number of employees in each state.

Click the $2-$Summary worksheet. In cell $\sqrt[\phantom{2}]{3},$ insert the COUNTIF function to count the number of employees in lowa, using the state abbreviation column and the state abbreviation in cell $13.$ Use mixed references for the range and cell to keep the row numbers the same Copy the function from cell $J3$ to the range $J4$:$J5.$