Select the column that contains the classification field and the numeric field that needs to be summarized.

Click the Data tab and the Category Summary button.

Select a column to sort by.

Click "OK" and Excel will classify and summarize according to the settings, and display the summary results in a new column.