Edit the Total Row Click on the Total number: It adds the Sum of the Amounts in this Column. You can change the operation from Sum to Average, Count, Max, Min or any of the options available in the extensive library.   8. Try It: Edit the Total Row Function Select: Cell H70. In this example, it is the Cell with the Total formula.   Select a Function: Average.   What Do You See? The average price will be calculated.   Memo to Self: How would someone know that this is the Average, and not the Sum? Labels, Labels, Labels. Exam 77-420 Microsoft Excel 2013 3. Create Tables 3.2 Modify a Table: Edit the Total Row

Table Tools->Design ->Table Style Options -> Total Row