Show or hide aggregate values in Datasheet view

• To show or hide aggregate values for all columns in the list, click Totals on the list toolbar.

  If the Total row is not visible, it appears at the bottom of the list. It displays the sum of values for numeric columns, and if there are no numeric columns in the list, a count of non-empty rows in the last column in the list. If the row was visible when you clicked Totals , it will be hidden.

• To show or hide aggregate values for one or more columns in the list, do the following:
  1. Click a column in the Total row.
  2. From the list of aggregate functions, select None to hide the total value. Select a function other than None to display a total value.