In this lesson we set up the agent performance data table from the data we collected in the Google Form. We use SUMIF() and judicious $ signs (to make references absolute) to create the table quickly. Once the table is ready, we use that data to create the agent performance chart.
Learning Objectives in this lesson:
=SUMIF('Agent Responses'!$B:$B,$A20,'Agent Responses'!C:C)