Let’s assume you are working with a data table that has a limited number of categories by which you want a count; you can use the COUNTIF worksheet function to solve this problem. For example, you have a data table that has two columns. Column A could be the names of clients, and Column B could be the names of the staff member responsible for that client. There are only half a dozen staff members, but many clients.
In Column E, list the names of your staff, one staff per row starting in row 2, since row one is the column name.
In Column F, beside the first staff, enter the following formula:
=COUNTIF($B$2:$B$200,E2)
Make sure you replace $B$2:$B$200 with the actual range of your original data table. (You could use a named range if desired.)
Copy this formula (cell F2) into the other rows of Column F beside each staff member’s name.
The information in Column F represents the number of customers for each staff member.
In Column E, list the names of your staff, one staff per row starting in row 2, since row one is the column name.
In Column F, beside the first staff, enter the following formula:
=COUNTIF($B$2:$B$200,E2)
Make sure you replace $B$2:$B$200 with the actual range of your original data table. (You could use a named range if desired.)
Copy this formula (cell F2) into the other rows of Column F beside each staff member’s name.
The information in Column F represents the number of customers for each staff member.
RSS Feed