In the range L4:N13, Tiana set up an area to summarize some data about the servi

In the range L4:N13, Tiana set up an area to summarize some data about the service representatives handling the customer support calls. First, she wants to count the number of calls each service representative handled. In cell M5, enter a formula using the COUNTIF function and a structured reference to the Service Rep column in the Calls table to count the number of calls Barry (cell L5) handled. Fill the formula into the range M6:M13 without formatting.
Requirements: Explained how to use countIF function to complete

Leave a comment

Your email address will not be published. Required fields are marked *