Lesson 42: Agent Performance stacked bar chart

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:

  • Use SUMIF() to aggregate the agent performance data
  • Create agent performance summary table and chart


=SUMIF('Agent Responses'!$B:$B,$A20,'Agent Responses'!C:C)


Link to the official Google documentation on the SUMIF() formula