Summary fields are calculated fields added to the last row of each column in the imported MySQL table. The drop-down list for each summary field in the resulting worksheet includes functions such as Average, Sum, Min, and Max.
This feature was added in MySQL for Excel 1.3.0.
The Add Summary Fields option (deselected by default) is listed on the Import Data dialog:
Enabling this option adds a row of summary fields for the appropriate columns in your imported data. Notice the newly created row on the bottom:
Select the row to reveal a down arrow, and click it to display a set of summary options:
For example, choosing Sum:
Adjust each summary field accordingly.