You can do this by creating a summary chart, which uses subtotals from columns of data rather than data in individual cells. Select the cells that contain your data. Click "Data" in the Excel ribbon.

Learn how to quickly summarize Excel data on-the-fly using these easy-to-implement features. Summarizing data is one of Microsoft Excel’s main functions. The good news is that a lot of number ...

Since I was intent on summarizing and understanding the data from the Excel sheet, I focused on the Formulas page of the platform where your data can be input, then generated or explained.