Problem: I need to build a summary table using COUNTIF functions. How can I enter one formula that can be copied?
Strategy: Use a cell reference as the second argument in the COUNTIF function. Here's how:
- Set up a table below your data and place all the possible values for a column, such as department, in column A.
- In column B of the first row, enter =COUNTIF($E$7:$E$62,A1). Note that you should press the F4 key after selecting E7:E62 to make the first range absolute. This will allow you to copy the formula to other rows.
- Copy the formula down for the other departments.
- Count of records by department.