$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.

ick 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 kee. the row numbers the same. Copy the function from cell $J3$ to the range $J4$:$J5.$