Using a Pivot Table in Google Sheets
Pivot tables in Google Sheets summarize data. Look for a column of data that has REPEATING information. Use the data menu to choose "Pivot table" and in the sidebar add for "Rows" the column of data that you want to summarize by. Choose the column of data for "Values" in the sidebar for what information you want to show summarized.