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 J$3$ to the range J$4$:J$5.$