If you are working with a list in Excel and you click on a cell in the list, the list toolbar should appear.

You can see a button on the list toolbar that is labelled Toggle total Row. Clicking on this button will display another row in the list, with the word Total in the first cell directly beneath the blue asterisk. If you click on any cell in this new row, you will see a downward pointing triangle indicating a drop list.

If you display the drop list from a cell in the total row you will see a number of options.

·              None will show nothing in the total row for this column

·              Average, will show the average of numerical values for the column

·              Count will show the number if items in the column

·              Max will display the maximum item for the column

·              Min will display the minimum item for the column

·              Sum will display the sum of numerical data in the column

·              StdDev will show the standard deviation for numerical column data

·              Var will show the variance of numerical date in the column.

You can select each cell in the total row in turn, and choose an option from the drop list apply to the particular column of data.

In the following example, the total row shows the minimum (closest) invoice date, the average invoice total, a count of the invoice numbers, and nothing under the company name column.

If you add data at the next record (blue asterisk) position, the values in the total row cells will be recalculated accordingly. If you want to change what is displayed in the total row, you can click on any cell in the row and choose another option from the drop list to design the total row as you see fit. You can hide the total row by clicking the Toggle Total Row button on the list toolbar.