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) appears on the Import Data dialog as shown in the figure that follows.
Enabling this option adds a row of summary fields for the appropriate columns in your imported data. Notice the newly created row appended to the existing rows shown in the next figure.
Select the row to reveal a down arrow, and click it to display a set of summary options shown in the next figure.